I've developed an SQL 2008 SSIS package that needs to run under several different configurations.
The selected configuration must be set at run time. I'm using SQL Server to store the configurations.
Due to security restrictions and multiuser considerations, I cannot use indirect configuration selection via an environment variable. In the dtexec command line
I’ve tried using several variations of /Set \package.configurations[Configuration1].properties[ConfigurationFilter].value;DL1 without success.
Is there a way to set the Configuration Filter property from the dtexec command line?
What is the proper syntax?
View Complete Post