Hello Friends, I have created my package in Dev env and now i have to run that package into production. So i figured out that i need to create a config file and make necessary changes to connection string and move both config file and ssis.dtsx pacage to production server but when i run this package on production i get an error message . ... i am loading data from a file to sql server and i also moved the file,DTSX pacage and as well as the config file but i still get the error DTS_E_Cannot acuire connection from connection manager. The acquire connection method to call the connection manager "C:\test\test.mdb" failed with the error code 0XCO209302

You're probabally not telling the package where the config file is, so it is using the default value for the filepath that you defined in the package. How are you executing the package in production? DTexec or SQL Agent Job?Chuck

Thank you chuck for your quick response.. i am using DTEXEC. I also tried to deploy the package and createdd a menifest file and copy menufest file, DTexec package and the config file and then i double clicked on the menifest file on a production server and deployed the package in particular directory. Now i have config file and the dtexec package on my desired location but if i run the package i get still get the same error message Error:- DTS_E_Cannot acuire connection from connection manager. The acquire connection method to call the connection manager "C:\test\test.mdb" failed with the error code 0XCO209302 I have the MDF file there already on the above location but not sure why it is still failing I have the MDF file there already on the above location but not sure why it is still failing

When using DTEXEC use the /Conf flag and specify your config file location/nameChuck

Thank you Chuck...but unfortunately i am still getting the same error

Nishant, Thanks for your post...i checked my config file a couple of time but still getting the same error..I am loading Data from Access to SQL and getting the error.... For testing purpose i created a package for loading the data from txt file to sql and deployed it to different server and to my surprise that worked fine but when i try to do this with Access data getting this error