SSIS skip bad row

Expand Post »

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

Similar Threads

What are Bad Clusters? in Troubleshooting Dead Machines
program with padding a string. in C++
Hard drive constantly being accessed in Windows NT / 2000 / XP
help to optimise data base structure in MySQL
Need help with a loop in C++

csihosting

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: MS SQL Recursion problem

Next Thread in MS SQL Forum Timeline: Restore Database from a Remote Backup

DaniWeb Message

Cancel Changes

User Name
Password