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?

Thanks

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


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