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 |
|
supertiti
Starting Member
1 Post |
 Posted - 2005-05-29 : 13:57:26
|
| I'm creating a package to import a set of 5 very large text tables, they all have the samestructure (515 fileds). I would like todo it all in one single package running paralleltasks.However, I'm force to map, source and destinationfields, for each of them !!!Does anybody knows of a way to copy the "Transform Data Task" ??.I can copy the connections just fine, butthe "Transform Data Task" arrow doesn'tallow to do that.I know that I could do a "Save as" and create5 DTS packages but I would like to have it all in one.Any help will be gratly appreciated.Thanks ! |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-05-31 : 05:01:54
|
| As far as I'm aware, it's not possible to copy these tasks in the DTS GUI. I'd advise against creating five packages to do essentially the same thing. You could create a single package that just does the transform data task and then execute this multiple times in parallel from a calling package (via the Execute Package task or an ActiveX script) passing in the source and destination.Alternatively, you might want to think about using a bulk insert task instead as this can easily be copied and you can use a single format file for all five tasks.Mark |
 |
|
|
|
|
|
copying Transform Data Task