SQL SSIS import fails due to bad format on rows
Posted on 2007-12-04
SQL SSIS imports fail if any of the rows are misformatted. Access simply logs the rows it cannot import and skips them. SQL Management Studio fails the whole operation.
Is there any way to set Management Studio up so that it just puts aside bad rows? I know this can be done in SSIS package code, but that is a pain. Anyways, even that fails the whole package for many format issues.
I have been looking high and low for an answer to this issue and cannot find one.