sql server dts: Copy column transformations -- sql server dts

Copy column transformations

Andy
4/28/2006 6:13:01 AM

sql server dts: I have a data pump task in one package that uses a copy column
transformation. I would also like to add this same transformation to another
package. Is there any easy way to copy the transformation and place it in
another package or am I stuck doing the mappings all over again? If it was
ActiveX I could obviously copy the script over. Is there any way to export
out of disconnected edit?

Re: Copy column transformations

Allan Mitchell
4/28/2006 12:20:41 PM

You are pretty much stuck doing the mappings again although (and this is the
long way around) you could script out to VB, copy the relevant section,
script the destination package to VB, paste in the code and save back to SQL
Server.

--

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]