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.