Hi everyone,I have the following question. I have an SSIS package and it has in SSIS in BIDS 'Enable package configuration' and a full path to a file. The packages works ok and reads from this file.If I invoke the same package from sql agent as a job step and apply another configuration file in the job step (in tab COnfigurations), the package still uses the one in BIDS. Shouldn't this new config file overwrite the one from BIDS or?Thank you Maria

Hi Maria,The configuration in your BIDS is overlapping with the configuration in the sql agent. First, It's reads the value from the configuration in the sql agent and then it reads the value from the BIDS, so it will take the last value.1) If you want to use the configuration in the sql agent, you can disable the configuration in the SSIS package.2) If you want to use the BIDS configuration, you can change the values in the BIDS configuration files and gets the new result.Thanks,Ketan

Thanks a lot. I simply removed the configuration file in BIDS and now the configuration in sql agent is applied.Maria

This seems counter-intuitive to me. If I'm running a package in a job and supply configuration file values in that job, I would expect the values in those config files to override the values stored in BIDS. In that case, the BIDS values should be read first and then the configuration in the SQL Agent, not the other way around.

It absolutely does NOT work! SSIS Configuration is one of the worst things I've ever experienced. Imposible to configure and imposible to reuse, unless you are dealing with simple things like strings etc. YOU CANNOT CONFIGURE ANY CONNECTION MANAGERS!!!

Maria, Ketan, I seem to have the same issue but the fix does not seem to work for me. Can you let me know exactly what you do? i.e. Do you take the dtsx in the bin or in the project folder? Do you delete the ssis from msdb before reimporting it? Do you redo the job (hopefully not)? Is disabling the file sufficient or do you also remove them from the list? I can't seem to get results and don't see what I am doing wrong! I have a variable containing the path of my log file and the SSIS can't seem to pick it up from the config file!

Got theanswer to my late question: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/711b59e4-17c0-4f7a-8a15-9cbb7b93cb4e All properties in the config file must exists in the ssis. In other words, If I edit the ssis to remove vars, connections or others, I cannot use my old config files. I must first clean them up so that I remove the corresponding to the properties removed in the dtsx. Maybe this is your issue as well Janus?

Janus: Normally, I would agree with you, but we were able to configure all connection managers. Where were you stuck? Many Regards, MM

The configuration files are NOT impossible to configure. You just need to know what you are doing. The issue with the SQL Agent job using the configuration supplied in BIDS is because of the enable package configurations checkbox in the package. Uncheck that box before deploying the package and it will work as you expect it to. As for the conneciton managers configuration, I'm not sure what you are doing, but we use the InitialCatalog and ServerName parameters (For SQL Server connections) in the config file and it works great. For ODBC/OLE connections, we use the ConnectionString, InitialCatalog, Username and Passwrod parms. If you provide the config file, we might be able to help.