I have a package with a corresponding configuration file. If I open Sql server management studio and i connect to SSIS and right click to import a package, and then select to store the package in SQL Server (not on the file system).... What happens with the configuration file? Does the import take the values from the configuration file and place them in the package which then is stored in SQL Server? Or do I need to put the configuration file someplace on the SQL Server where the package is imported so it can access it when it runs? I'm a bit confused about what goes on there? For example, I tried using the build command and then running the manifest file to import using the wizard and when it does that it copies the configuration files to a default location within the c:\program files\microsoft sql server directory. Thx. R-

There is now an utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS: http://ssisconfigeditor.codeplex.com/