SSIS package not using configuration from SQL server table

Is the configuration table in the same database that is being set from the environment variable?

Thats for your reply Rafael and John.

The configuration is in the same database as set in the env variable.

I am following the same instructions as in

http://rafael-salas.blogspot.com/2007/01/ssis-package-configurations-using-sql.html

This is procedure I followed for package configuration in that order-

1. SSIS --> Package configuration

2. Add --> Configuration type = Environment variable --> Choose the env variable I had created for DB connection --> From properties list choose connection string for the DB connection manager --> Give a name --> OK.

2. Add a second configration of type SQL server --> Choose Specify configuration settings directly --> Choose the db connection manager --> specify the configuration table --> Set configuration filter --> Next --> Choose all objects for configuration

Al I missing something here?

Thanks

Karthik

I tried that too. I ran it manually from Development studio...tried running by double clicking on the dtsx file. No sucsess. It is not picking up the settings from the SQL server config table.

I must be missing something..I haven't seen anybody else having this problem.

Thanks

Karthik

I've used both XML files and environment variables to set an initial connection for my SQL configs, and set the rest of my configurations from the SQL table. I've never had any problems with this approach.

Can you confirm that the enviroment variable configuration is the first item in your configuration dialog?

Is it a system environment variable, or a user environment variable?

kforkarthik wrote:

Phil..it is a system env variable...and I can that the package is picking up the env variable correctly.

How do you know?

Do the values for the other configurations reflect the SQL table value in the dev environment? If not, are you getting any warning messages when you open the package?