February 14, 2006 at 1:42 pm
Hi everyone
I am hoping someone else has had this problem, because I am stumped. I have a package that works fine with no configuration file. However when I try to add the configuration for the Oracle OLE DB connection manager to the Package Configuration file I get the following error.
[SRC_DBName_TableName] Error: The AcquireConnection method call to the connection manager "DBName.UserName" failed with error code 0xC0202009.
Does anyone have any ideas?
Thanks
Erich
February 15, 2006 at 7:52 am
Take a look at the connection string using this technique: http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx
and see if there are any problems with it.
And remember, SSIS will NOT store passwords in the config file for you, you have to put it there yourself.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
February 15, 2006 at 7:57 am
Just a guess, but when I used the configuration wizard, it stored the Oracle password as "******" instead of the actual value. When I edited that to an actual password value, it worked fine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 15, 2006 at 8:41 am
Thanks guys, somehow I missed that.
Is there a way to encrypt the passwords that show up in the configuration file?
February 17, 2006 at 8:38 am
Unfortunately not. Hopefully encryption of dtsconfig files will come one day.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply