H I have designed a Package, Which is using a XML config file for Configurations. In my developer environment it is stored in C Drive.. When I moved my package to staging environment for testing, their i need to Place my config file in D Drive.. And now.. I am using DTexe. command to Execute my Package their in my command, I have mentioned my config file location using the Parameter \Config their I have specified my config file location in Stg Environment ( ie::: D Drive..) and My Problem I try to Run my command, it is giving the error that , Unable to load the File (C: ... ) ie) C Drive location Which I have Used in Dev environment, But still my package is pointing to That file location.. Why it is happening..? What I missed? Thank you RAVI

could you paste your DTEXEC command line exactly here?http://www.rad.pasfu.com

You will still have a reference within the SSIS package to your c:\ drive. You can use multiple config files for a packag so although you are specifying a config file in the command, it will also be trying to reference the one explicitly defined. One way of avoiding this behaviour is by storing the location to the configuration file in an environment variable and modifying this on each machine. http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm every day is a school day My Blog

The simplest way is to create a deployment package. This will enable you to change the location of your config file. http://msdn.microsoft.com/en-us/library/ms140117.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi, IF I don't want to deploy my package I ma just using the package from File system. in that case i can run by using the command only , in that case How can I do..

Have a read of this article http://bi-polar23.blogspot.com/2007/05/flexible-file-system-deployment.htmlJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

you can also deploy the package with DTUTIL command <cite>http://msdn.microsoft.com/en-us/library/ms162820.aspx</cite>http://www.rad.pasfu.com