August 2, 2007 at 8:49 am
Hello,
I am having a problem using SSIS. All that I am doing is, just bring data from Oracle to SQL2k5. This is a simple package and no fancy or complicated stuff.
I deployed the package and calling thro' my VB.NET program. First of all, I am not getting the data from Oracle. Also, when I did execute this package, it works fine. At times, it throws error as follows:
"
Error SSIS error code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Server.TestUserId" failed with error code 0xC0202009. There may be error messages......."
Why I am getting this error.
(a) Do I need to save the password in the package?
(b) Do I need to install the SQL Server 2005 Service Pack 2?
Any help will be highly appreciated.
thx,
Ram
August 3, 2007 at 3:11 am
You should install SP2 for many reasons.
A package will not save sensitive information such as passwords.
Your best bet is to use a config file to set the passwords for the connection.
Also, see: http://technet.microsoft.com/en-us/library/ms141747.aspx for protection level information.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 3, 2007 at 2:26 pm
Crispin,
First of all, thanks for your response. Can you please give me a step-by-step approach how to setup and modify the config files? This ssis is driving me crazy.
None responded in this forum on this topic except you. I must really appreciate your time.
With Best Regards,
Ram
August 3, 2007 at 3:03 pm
Have you looked in BOL?
In BIDS, go to Menu > SSIS > Configurations.
Enable it and add new. Go through the wizard and from the tree, select properties you want to store in the config file.
Once saved, you can edit the file in any text editor.
HTH
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply