Get DTS datapump source columns

20 May 2010 3:24 PM

Mark

Hello,
Using VB.NET 2008 Express edition.
Added a reference to DTS Package Object Library (DTS.dll)

I am having no trouble looping through tasks and steps. However, when I
come across datapumps, I have a need to get the source column names, but
cannot figure out how to access them. They do not appear to be included in
the Task.Properties collection. Can anyone help me out??

Thanks, Mark

26 May 2010 1:44 AM

a a r o n . k e m p f @ g m a i l . c o m

I'd move back to vb6, buddy

seriously, sorry.. I miss DTS / Vb6.. It blows my mind that we can't
save a SSIS package as a VB.net script.

On May 20, 8:24 am, Mark <M***@discussions.microsoft.com> wrote:
Show quoteHide quote

> Hello,
> Using VB.NET 2008 Express edition.
> Added a reference to DTS Package Object Library (DTS.dll)
>
> I am having no trouble looping through tasks and steps. However, when I
> come across datapumps, I have a need to get the source column names, but
> cannot figure out how to access them. They do not appear to be included in
> the Task.Properties collection. Can anyone help me out??
>
> Thanks, Mark