DTS Data mismatch….Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Data mismatch….Error

Hi gurus, The Task is to transfer a text file data into a Table of the Database.
This text file has some rows which might conflict the Datatype of the
Target Database. Say, out of 100,000 rows some 10 rows are of Char datatype data (In the Test file)
where as the Target column datatype is of Int. During, How can I ignore those datatype confliting 10 rows and have rest of the
rows transfered in the target Table. This time I am Using DTS for importing the Text file data in to a Database Table. Very urgent, Please Help. raj
you can use Multiphase Data Pump http://www.sqlservercentral.com/columnists/dasanka/themultiphasedatapump.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka