hi

I wanted to know, is this possible?

I am transforming about 1 miilion rows from text file into SQL Table, There
is one column is integer, There are some changes to have alphanumeric in flat
file.
while inserting this column into interger column in table dts will fail, In
Informatica, we can insert into separtate table and continue transformation.
Once transformation is done, we can validate the error rows.

Like this possible in SQL Server 2005, if so, any help

Yes, you can easily do this in 2005. SQL Server Integration Services or SSIS
is the 2005 equivalent of DTS. On the Data Flow tab of the package designer,
double-click on the transformation that is failing on some rows. Click the
Configure Error Output button. In the Error column choose the option to
Redirect Row. Now configure the red error output from the transformation to
the destination table you want it.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk



[quoted text, click to view]