table SSIS_Configurations

VARCHAR(100) NOT NULL,

NVARCHAR(255) NOT NULL,

NVARCHAR(20) NOT NULL,

NVARCHAR(1000) NULL

)

 

Create an environment system variable called eg. SSIS_ROOT

Enter the connection string to the above db into the value

eg. Data Source=.\SQL2008; Initial Catalog=SSIS_Config; Provider=SQLNCLI10; Integrated Security=SSPI;Auto Translate=False

 

Create new SSIS package

 

Create OLEDB connection called Configuration – point to SSIS_Config db

 

Create a new SSIS configuration…

 

Type = Environment Variable

Variable = SSIS_ROOT

 

Next > Select ConnectionString property of Configuration connection manager

 

See http://msdn.microsoft.com/en-us/library/cc671625.aspx for more info