Hi all
I am trying to create indirect package configurations so that:
1) My configuration data is stored in a SQL Server table, and
2) The location of that table is stored in an environment variable.
Achieving #1 is easy, but when I hit the "Configuration location is stored in an environment variable", I strike problems. I can specify a environment variable no problems, but there doesn't seem to be anywhere in the documentation to describe the syntax of WHAT should go in that environment variable.
HELP!!!!
Thanks in advance
Jays
SQL Server Indirect Package Configurations
devoted
Hi Simon
I copied the connection string from method #1 verbatim. It looks like this:
"Staging";"[dbo].[SSIS Configurations]";"DWParam1Comm";
Unfortunately, it doesn't seem to work :-(
Btw, are you saying that we MUST already have a pre-defined connection in the package before we can use this method
I had rather hoped that I could put the fully qualified connection string to my database in place of <connection>.
It seems to me that if I can't do this, that this methods is nearly useless :-(
Thanks in advance
Jays :-)
Bartosz Wójcik
If you create 1 you will see in the connection string the format,
"<connection>";"<schema>.<table>";"<filter>";
So this has a dependency on a connection, you will have to figure out the order that the properties to be set.
For complete flexibility I am a strong believer of file based configurations.