MS SQL Server DTS - DTS Count Columns

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS Count Columns

Peter Neumaier

2006-01-20, 7:23 am

Hi NG!

I was searching the web for an ActiveX-solution for counting columns in
a row when importing a txt file with DTS. Can anybody provide some
samples or useful web links?

Thx a lot!
Peter

Allan Mitchell

2006-01-21, 7:23 am

Hello Peter,

What you could do is count the amount of transformations there are and look
at how many SourceColumns there are in the Transformation. Add them together
and this should give you the answer

Allan

> Hi NG!
>
> I was searching the web for an ActiveX-solution for counting columns
> in a row when importing a txt file with DTS. Can anybody provide some
> samples or useful web links?
>
> Thx a lot!
> Peter

Sponsored Links