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 |
|
ckndr47
Starting Member
3 Posts |
 Posted - 2006-03-08 : 06:12:07
|
| Hello,I have 5 tables/entities at my source end (i.e. MS SQL), now what i have to do is to copy records from different columns (i.e. columns from those 5 entities) and then i will have to paste those columns at my destination end (i.e. MYSql) in 3 different entities. Now i am doing this mechanism through Transform Data Task. Its very simple if i have to copy records from 1 table to another but here i have 5 tables at the source end and 3 at the destination. All this has to be done with TRANFORM DATA TASK. Do you have any suggestion?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-08 : 07:42:16
|
| Yeah, write a SQL Statement to get the columns and info you need and put this in your source.. |
 |
|
|
ckndr47
Starting Member
3 Posts |
Posted - 2006-03-08 : 08:02:15
|
| Hay thankx RickD... i am already done with it.. |
|
|
|
|
|
|
DTS Multiple Data from Source to Destination