SQL Server Performance Forum – Threads Archive

DTS: File import with error logs and uninterrupted

I have multiple files(in one folder) to import into say tableA.
we have 10,000 records in all of these files. The import should be uninterrupted by any error in the transformation like say there was a datatype missmatch in one row then it should be logged some how and continue with the next row to import
do anyone have any idea how to do this Thanks in advance [B)] incubus

http://www.sqldts.com/default.aspx?600
http://www.windowsitpro.com/SQLServer/Article/ArticleID/6196/6196.html
http://databasejournal.com/features/mssql/article.php/3306871
.. links to help you on the information in addition to Books online. Avoid DDQ with lookups as you cannot do fast bulk insert. Use temp table and join itin data pump. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Additionally,
U can enble Multi Phase Data pump
Check whether this is help full,
[/url]http://www.sqlservercentral.com/columnists/dasanka/themultiphasedatapump.asp[/url]

]]>