Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS and BCP

Author  Topic 

sardinka
Posting Yak Master

142 Posts

Posted - 2004-08-25 : 11:56:45
I have a dts with the bcp task however I would like to add some error support in case some of the row is fail to load. How do I do this?

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-08-25 : 14:11:18
I think you can use Multiphase Data Pump. Refer http://www.sqldts.com/default.aspx?282 ..

------------------------
I think, therefore I am
Go to Top of Page

sardinka
Posting Yak Master

142 Posts

Posted - 2004-08-25 : 15:06:53
I read the topic and turn on the muptiphase data pump, however it did't help me with the bulk insert task. I have no additional option in my task after that step.
Please help me...
Go to Top of Page
   

- Advertisement -