sql server dts: Modifying destination in DataPump -- sql server dts

Modifying destination in DataPump

Brandon Lilly
10/7/2004 12:57:16 PM

sql server dts: 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

Re: Modifying destination in DataPump

Allan Mitchell
10/9/2004 12:12:02 PM

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

[quoted text, click to view]