Post reply

using a config file

  • December 30, 2009 at 6:35 am

    #215004

    Ive created a package that transfers data from several different access tables into sql server. The access tables have a standard username but no password. If I run the package without using a config file, everything is fine, but as soon as i specify a config file, the access files will no longer open. Ive manually added the username to the config file, but no password is required. (Ive even tried specifying a password and adding it, but it makes no difference)

    Im getting this error

    DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

    ive set the protection level to

    DontSaveSensitive

    nothing works, can anyone help ?

  • December 30, 2009 at 3:02 pm

    #1097679

    What type of config are you using XML? Are you setting the value of the connection manager directly from the configuration?

  • December 31, 2009 at 2:26 am

    #1097784

    Note that even if you specify a password in the configuration file set up (in the wizard), it will not be saved in the physical file. You need to add it manually to the physical file later, after deployment.

  • December 31, 2009 at 2:52 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply