Narizz28
MIS
- Mar 8, 2001
- 161
I am having an issue trying to capture my exceptioned records. WIN2K, SQL2K. I turned off 7.0 Format and turned on Error Txt, Source rows and Dest rows. However I am only getting the Error txt, and the package as a whole completes successfully (I jacked the error count up to 9999).
The particular error I am getting is "too many source columns", as I am running an import from a Pipe delimited file, and there are pipes in certain record field exported as \|. This is causing the import to recognized them as the delimiter, thus too many columns in the record. This much I understand.
My question is this - is a "too many columns" error not exceptionable, ie. can't be exceptioned out due to the row as a whole not being understood by the trasnform step?
I am not looking to fix the source data at this point, as these packages are still in developement, and the error text file does give me the row number, and in the future, will clean the 54 of 2M records in the source system to remove the pipes. I am merely curious as to the exact reason the rows are getting written to the .source file, or if there is a way to modify the transform to write it out instead.
The particular error I am getting is "too many source columns", as I am running an import from a Pipe delimited file, and there are pipes in certain record field exported as \|. This is causing the import to recognized them as the delimiter, thus too many columns in the record. This much I understand.
My question is this - is a "too many columns" error not exceptionable, ie. can't be exceptioned out due to the row as a whole not being understood by the trasnform step?
I am not looking to fix the source data at this point, as these packages are still in developement, and the error text file does give me the row number, and in the future, will clean the 54 of 2M records in the source system to remove the pipes. I am merely curious as to the exact reason the rows are getting written to the .source file, or if there is a way to modify the transform to write it out instead.