DTS Count Columns

#1

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

#2

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

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Count Columns

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Count Columns - 01-20-2006 , 05:24 AM

Re: DTS Count Columns - 01-21-2006 , 05:06 AM