troubleshooting Question

Package Deployment steps

Avatar of gomz_5
gomz_5 asked on
Microsoft SQL Server
12 Comments1 Solution554 ViewsLast Modified:
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.

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 mostly.

Thanks
ASKER CERTIFIED SOLUTION
Reza Rad
Consultant, Trainer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros