On the destination tab of the DataPump task there are a list of columns at
design-time. I programatically want to add/remove columns to this list.
What property of the DTSDataPump task can I access to modify the list of
columns? I thought it might be DestinationColumnDefinitions, but there
don't appear to be any (I looped through the collection with FOR EACH and
got no results).

It is causing a problem because I run a transformation with only the columns
I want in the source and destination, but the resulting file contains ALL
column headers, but data for only the columns I told it to transform.

Thanks,

Brandon

In your package you have Transformation objects. These have SourceColumns
and DestinationColumns properties which contain Column objects.
You can play around with these to get your desired result.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Brandon Lilly" <brandon.lilly (AT) no_spam (DOT) medevolve.com> wrote