SSIS Package Configurations 05
Building on the first videos to demonstrate how a SQL Server connection string may be split out to define the Server Name and Database Name and passed through the DTS Config file or as part of the command line parameters when calling DTExec.
Example DTExec executable call from a command prompt:
dtexec.exe /FILE "C:\My Project\MyDTXS.dtsx" /CONFIGFILE "C:\My Project\MyConfig.dtsConfig" /SET \Package.Variables[User::MyVariable].Properties[Value];"My Variable Value" /SET \Package.Connections[MyDB].Properties[InitialCatalog]MyDatabaseName