I am new to SSIS 2005ÃÂ packages but have written many in DTS 2000.
I am importing a CSV flat file intoÃÂ a SQL server table with SSIS 2005. How doÃÂ I tell the Dataflow task to redirect rows that don't have the proper number of columns into a Text log file so I can inspect the bad rows later?
I haveÃÂ pointed the Red Error arrow to a text file and defined all the Columns to redirect the error to the text file. I have set the Max error count to 200. However, the entire package fails at the first bad row in the PrimeOutput() method, indicating that Column 13(the last one in the Row) is missing inÃÂ a particularÃÂ row. I have tried setting Ignore the error, but that doesn't work either.
I have created a DTS 2000 package that works on the same CSV input and the same SQL table destination. It seems to have no problem with my instructions.
IÃÂ must be missing something. Can someone tell me what it might be?ÃÂ I really would like to use SQL 2005 or even SQL 2008 because of the new features available, but I am stuck on what I thought would be a very easy first step (because it is very easy in DTS 2000).
Any help would be appreciated. Thanks...
View Complete Post