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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-11-15 : 10:39:34
|
| Hi All, am new to IS 2005 but i've worked with DTS packages in 2k, i like to know if its possible to do multiple data transforms in IS, i want to copy 2 tables data from one database to another database. |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 10:45:09
|
| Yes, they can run parallely if this is no precedence required. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-11-15 : 10:50:13
|
| Alright, so you can only have one data flow between the source and destination i would have to add another source and dest OLEDB to the datflow window ? |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 10:54:19
|
| On the GUI, it looks like you have two pair of each, but in reality, both source icons share the same connection/provider/data source. So do the destinations. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-11-15 : 14:31:45
|
| Yes, you'll need 2 sources, 2 destinations. You'll also need 2 connections, one for each database. |
|
|
|
|
|
|
Multiple Transforms