SQL Server Performance Forum – Threads Archive
DTS Data mismatch….ErrorHi 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