Hi All,

I have a package with a ActiveX transform data task that sucks a csv
file into a mssql 2000 table. The issue is that the CSV file may have
either 10 (File A) or 20 (File B) columns. What I really want to do is
say:

If FileHeaderInfo = 10 Columns Then
DTSDestination(001) = DTSSource(001)
...
DTSDestination(010) = DTSSource(010)
Else
DTSDestination(001) = DTSSource(001)
...
DTSDestination(020) = DTSSource(020)
End If

Now, I currently can't do this as the package will fail if I setup the
source/destination columns according to File A (10 columns) if a File B
(20 columns) is encountered (as I then can't use columns 11-20).
Likewise, it will fail at runtime if I setup the source/dest as per
File B (20 columns) and a File A is encoutered as it thinks columns
11-20 are missing...

Any ideas? Can this be done?

Cheers
Rob

You either have a different datapump for each "Length" and you test the
column amount at the start or you test the column length at the start and
rebuid the datapump each time.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"RobV" <rvarga (AT) swiftdsl (DOT) com.au> wrote