Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2013-06-21 : 12:19:18
|
| i have 2 Solutions (in package deployment model)i copy one package to another solution, and try change the datasource in the package (name and the database ,servername)when i execute the packge i got this error: [OLE DB Source [119]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DS_PR" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.my question is how change datasource , when i copy packge from one soultion to anotherthanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 12:40:47
|
| was the package having a project level parameter for connection manager?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-06-22 : 13:44:30
|
| no |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-23 : 02:20:30
|
| Is it getting value from a configuration?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
change Data Source