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 |
|
Haarish
Starting Member
30 Posts |
 Posted - 2009-09-01 : 07:39:14
|
| Hi All,I need to include a 'Transfer SQL Server Objects' task in the package that takes the source database at run time though the tables are always going to be the same. Is something like this possible?Thanks in advance,Haarish. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-01 : 07:50:36
|
| Sure. You can set the SourceConnection and/or SourceDatabase at runtime, using variables in the Expression. |
 |
|
|
Haarish
Starting Member
30 Posts |
Posted - 2009-09-02 : 03:14:16
|
| Thanks a lot YellowBug, because of the lack of time, I copied the whole table between the databases using an EXECUTE SQL task. |
|
|
|
|
|
|
Transfer Objects task