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.