October 24, 2009 at 6:11 pm
Hi Experts
I ve been trying to deploy my package. I basically have three connection managers - one each for flat file , oracle and sql server connection. My package works perfectly when i run it on my computer. What I d like to do is make it more configurable: Allow users to enter the connection string for their databases.
This is where my problem starts:
1. Tried creating a dtsconfig file and the deploymentmanifest file.
Once this was done, my package fails to run in my own system even with the rite credentials. I keep getting an acquireconnection method failed message.
So i tried a different method
2. Tried creating connection managers programmatically
I used C# to create the connection managers and provide a GUI to give the Connection string. This created the connection managers with the rite strings but my package didnt run.
Pls provide any guidance on how packages are deployed.
Thanks
October 24, 2009 at 9:27 pm
Are you using Trusted connections or explicit Username/Passwords in these connections?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 24, 2009 at 9:41 pm
Hi
I m using explicit username and pwds .
Thanks
Gomz
October 25, 2009 at 6:58 pm
What is your "Protect Sensitive Data" setting?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply