I've been unable to get my package to pick up its config data from a database config table - despite having done this many times before.
To troubleshoot, I built a package consisting of a script task and one variable, whose value ("ValueFromIDE") I then linked to the config table using the wizard. (I also let SSIS create the table for me.)
When the wizard was complete, I verified that the table had been created and that there was a value for my variable. With sql I update this value to "ValueFromDB". When I run the package, the script task msgbox's the value of the variable.
I consistently got the value "ValueFromIDE" i.e. it didn't pick up the value from the DB.
If finally worked out that if my created my config table was on a different server it worked, and subsequently I observed that it appears only to work on default instances (or at least not to work on named instances.) i.e. Server01 works but Server01\inst01 does not work.
I was very surprised by this, and have not found any confirmation on the web.
Can any of you confirm or deny this? If you've got a named instance, does it work for you?
(I'm on SQL 2005 - more below)
Thanks for any help you can give!
Microsoft SQL Server Management Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer6.0.2900.2180
Microsoft .NET Framework2.0.50727.3053