Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSIS_Config_File

Answered SSIS_Config_File

  • Monday, May 21, 2012 2:55 PM
     
     
    Sign In to Vote
    0
     

    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

     

All Replies

  • Monday, May 21, 2012 3:00 PM
     
     
    Sign In to Vote
    0

    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

     
  • Monday, May 21, 2012 3:37 PM
     
     
    Sign In to Vote
    0

    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


    • Edited by VATiger Monday, May 21, 2012 3:39 PM
    •  
     
  • Monday, May 21, 2012 3:40 PM
     
     
    Sign In to Vote
    0
    When using DTEXEC use the /Conf flag and specify your config file location/name

    Chuck

     
  • Monday, May 21, 2012 3:59 PM
     
     
    Sign In to Vote
    0

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

     
  • Monday, May 21, 2012 6:53 PM
     
     
    Sign In to Vote
    0

    this is configuration issue.

    open package and check package configuration in which you will find error.

    correct your configuration first,

    Regards, nishantcomp2512 Please mark posts as answered where appropriate

     
  • Monday, May 21, 2012 11:18 PM
     
     
    Sign In to Vote
    0

    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

     
  • Friday, May 25, 2012 7:51 PM
     
     Answered
    Sign In to Vote
    0

    Thank you all for all your suggestions...I figured out the problem and it was an Ole db thing when i was saving package it was not saving as jet ole db provider

    • Marked As Answer by VATiger Friday, May 25, 2012 7:51 PM
    •