Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS & Config File

Author  Topic  Cathryn Starting Member 4 Posts Posted - 2010-10-07 : 11:08:04 I'm having problems with a package running by a job and using a config file. My package security is EncryptSensitiveWithUserKey I have a config file with connections strings, catalogs and passwords for SQL connections, Oracle connections and file shares I can obviouosly run the package in Integrated Services myself but no one else can which includes the agent. The package is deployed using File system. The config file path doesn't not have an actual path so it looks for it in the same directory that the dtsx file that it was deployed from exists. What am I missing? Shouldn't the package use the config file to connect to the databases with the passwords provided which shouldn't matter who is executing the package? Thanks!