Variable defaults to zero in script task (SSIS)



Hi all,

I have a script task in my SSIS package where i use a user variable
that is read from the configuration file.
It works fine.
But if i had a new variable (of the type string) for some reason it
defaults to zero.


This is what i did.

Add New Variable (no default value, package scope, string type)
In package Configuration option i configured the value of the that
variable to be read from the file.
I added the Variable in the list of variables for my script task.


I also made sure that the configuration file did contain the
variable.Also if the configuration file doesnt contain the variable
then i get zero as default.


What am i missing...

TIA

.



Relevant Pages

  • Re: Purge all removed packages ?
    ... command to remove files that are part of a package but which are user editable and preserved when the main body of the package is removed. ... The port installs sample configuration files which you have to copy ... Thus the configuration file ...
    (freebsd-questions)
  • RE: [opensuse] How do I keep monitor from going to sleep
    ... install from source, etc., as opposed to say Windows, which will decide ... Isn't it really a matter of Windows not automatically installing third-party ... There really is no package manager analogy for Windows, ... can't change your configuration file automatically as it is not designed ...
    (SuSE)
  • Re: Creating configuration file failing
    ... pszItemName, Int32 cFilesToOpen, StringrgpszFilesToOpen, IntPtr hwndDlg) ... Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.Ru-nWizard(String wizardName, String newItemName) ... So I removed the existing configuration file through the provided ... wrong in this package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Reducing dependencies when initializing Log4perl?
    ... My goal is to have zero dependencies in my source code to artifacts ... such as configuration file locations or package names. ... MyLogWrapper is the only class that knows where the config file is, ...
    (comp.lang.perl.misc)
  • Re: SSIS, Excel & Package Configurations.
    ... I'm getting the 0xC020801C (cannot aquire connection) error when trying to ... You mention a configuration file, when I inherited this package, the config ... SQL2005 Database Table using OLEDB Connection Manager. ...
    (microsoft.public.sqlserver.dts)