December 30, 2009 at 6:35 am
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
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
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