sql server dts: Hey guys,

I am importing CSV files from a directory. These files may either have
5 columns or 4 columns (missing the last one).

I wish to import the 4 column version into an errors table in the db,
meanwhile the 5 column version is imported into the live table.

Anyone any idea how to go about this?

Stuart

Having had a short search on the web, would I be able to use a
'Multiphase Data Pump'? I may be able to use the Transform Failed
method??

Anyone?

[quoted text, click to view]
Use SQL Server SSIS .

Use Conditional Split task in Data Flow Task and split data on fifth
columns nullability.

It will give two result set one for which fift column is null and for
which is not null

Regards
Amish shah

If only we were using 2005.

Sorry I should have said we were using 2000!

Is it possible to count the columns in DTSSource??

DTSSource.Columns.Count???