I have previously created some DTS packages, in fact a rather large complex
project, in SQL 2000. I am trying to create a package in SSIS 2005 and am
finding it to be more difficult than the older DTS designer.
I have what should be a simple problem to overcome but cannot find the
solution in SSIS. Importing a comma delimited CSV flat file into a SQL table
is failing because a few rows do not have the correct number of Row
I would like to (for now) simply skip the bad rows and let the package
continue. I have changed the property of "Fail Package on Error" to "NO". I
have set the allowable errors to 50. But still the package fails on the
first bad source row.
I don't have the time to get a "formal" education in SSIS, as that would
cover many more topics than I actually need to know to get my current
Can anyone tell me the simple way to allow the package to skip source rows
if they have bad data that cause an error?
I tried to create an OnError event handler but I didn't get very far with
I suppose I can always re-install SQL Server 200 on my development machine
just to get the job done...but I hope that somebody can help me.