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

thanks