LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Integration Services (SSIS) and DTS » The AcquireConnection method failed with error code 0xC02020

The AcquireConnection method failed with error code 0xC02020

Options

Previous Topic · Next Topic

dshushack

Posted: Thursday, March 19, 2009 9:30:47 AM

Rank: Newbie

Joined: 3/19/2009
Posts: 1
Points: 3
Where do you live?: Switzerland

I am hoping you might give me some ideas where
to look. I have moved (by hand) an SSIS mapping file and external
configuration file from my local developer machine to our pre-production
server installing the files in two separate folders. In addition, I have
setup an SQL Server Job to execute the package (using an SQL Server
Credential / Proxy) to run the job. (the jobs specifies has the necessary
details specified in the Connection and Logging tabs of the SQL Job Manager
screen.

I have an IDs setup on this machine belonging to a domain groups
having full access to both both folders (where the
SSIS package and associated configuration file are located). The package I
have created basically connects to an Oracle database and reads in a record
which I output to a text file. In the package configuration file I have the
required Oracle ServerName, UserName and Password values saved.
The SSIS package is also set to the ProtectionLevel (DontSaveSensitive).

When I try running the package on the
PreProduction Server I get the message The AcquireConnection method call to the
connection manager IM_STATS_DB failed with error code 0xC0202009. Any ideas
where the problem could be? I am stumped .. and all of the searches on the
net have told me to use an external configuration file to manage sensitive
string.

Thanks for any help you can offer.
Regards Don

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.