Copy Group of Transform Data Tasks in Same Package

Question

Copy Group of Transform Data Tasks in Same Package

sslattery

Valued Member

Points: 68
More actions
August 29, 2008 at 12:52 pm

#70745

Hi,
I am modifying a package to use basically the same group of transform data tasks to generate slightly different data (slightly different criteria in the originating select). So there would be two sets of transform data tasks instead of one.
To save time is there any way to copy the group of 20+ transformations and paste next to the original group?
I know how to do it the slow way--from scratch.
Thank you.
Susan

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Sure you can select them all in BIDS and then paste them in the package. They will get a number added to the end of the name.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

If this is a DTS package, Jack's BIDS suggestion won't work and, unfortunately, there isn't a way to copy a Data Transformation task in DTS Designer. Lot's of connections and some tasks can be copied but not this one.

Greg

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Greg Charles (9/2/2008)
If this is a DTS package, Jack's BIDS suggestion won't work and, unfortunately, there isn't a way to copy a Data Transformation task in DTS Designer. Lot's of connections and some tasks can be copied but not this one.

Oops, since I don't have 2000 anymore I forget and assume everyone is in SSIS.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

sslattery Valued Member Points: 68 More actions · Answer 4

That's what I thought so I'm copying over the DTS package to another one (by Save AS), massaging the transformations, and then putting in an execute package into the orignal DTS package to call the "saved as" package.

We'll be moving to 2005 for these (changing DTS's to SSIS) eventually since everything else is 2005 in our environment.

Thanks for your responses.

Susan