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 |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-15 : 15:47:34
|
| Hello,I have a Sequence Container in the package with three Execute SQL Tasks. These tasks will be remaining the same in all the other (many) packages that I am creating. So, I was trying to copy this Sequence Container and paste it in the other packages as everything in it will be the same for all the packages.The container is getting copied fine, but there is an error in the Connection Manager.I was wondering if there is any way that we can set the connection manager via a Variable ((or any other way that you might know of).I would add here that for all the three Execute SQL Tasks, I have the same SQL Server Connection Manager. So, if there is some way to do this, then I will be able to successfully copy the Sequence Container in the other packages as well. Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 10:00:30
|
| you mean only server & database for three execute sql tasks will vary between packages? |
 |
|
|
|
|
|
Variable for the Connection Manager