SSIS skip bad row

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Nov 2009
Posts: 1
Reputation: csihosting is an unknown quantity at this point 
Solved Threads: 0
csihosting csihosting is offline Offline
Newbie Poster

SSIS skip bad row

 
0
  #1
26 Days Ago
I have a SSIS import file that imports a flat file that is in cvs format. I've been running into a problem where the input file that is retrieved from a third party has bad rows in it. These rows cause the import process to fail and it doesn't fully update the database. Is there a way to tell the SSIS package to skip any rows that can't be imported? Thanks
Reply With Quote Quick reply to this message  
Reply

Message:



Similar Threads
Other Threads in the MS SQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC