Friday, November 30, 2007

SQL:SSIS package configuration

What does "SSIS uses the package configuration to update the values of properties within packages at run time" mean?
Save the package configuration to Environment Variables

Create environment variables:ConnectStr and MyFile
Create an SSIS project;

Create a Package Configuration

After the configuration, value of environment variable ConnectStr will replace the ConnectionString target property; The value of environment variable MyFile will replace the Arguments of Execute Process Task.
Your package will execute against different values when the values of Environment variables change.