dbTalk Databases Forums  

copying Transform Data Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss copying Transform Data Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
supertiti
 
Posts: n/a

Default copying Transform Data Task - 05-29-2005 , 01:19 PM






I'm creating a package to import a set of
5 very large text tables, they all have the same
structure (515 fileds). I would like to
do it all in one single package running parallel
tasks.

However, I'm force to map, source and destination
fields, for each of them !!!

Does anybody knows of a way to copy the
"Transform Data Task" ??.
I can copy the connections just fine, but
the "Transform Data Task" arrow doesn't
allow to do that.

I know that I could do a "Save as" and create
5 DTS packages but I would like to have it all in one.

Any help will be gratly appreciated.
Thanks !

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: copying Transform Data Task - 05-29-2005 , 02:05 PM






You cannot copy and paste like this in the curent version of DTS. Sorry




"supertiti" <supertiti (AT) discussions (DOT) microsoft.com> wrote


Quote:
I'm creating a package to import a set of
5 very large text tables, they all have the same
structure (515 fileds). I would like to
do it all in one single package running parallel
tasks.

However, I'm force to map, source and destination
fields, for each of them !!!

Does anybody knows of a way to copy the
"Transform Data Task" ??.
I can copy the connections just fine, but
the "Transform Data Task" arrow doesn't
allow to do that.

I know that I could do a "Save as" and create
5 DTS packages but I would like to have it all in one.

Any help will be gratly appreciated.
Thanks !


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.