SmashAndGrab
asked on
SSIS package failing
Hi,
I have a very problematic SSIS package that uploads data from a CSV file to an SQL table.
Its working most of the time but is failing every so often and its obvious that its an issue with the CSV file data.
The errors are:
Message
Error: 2016-07-26 05:02:01.09 Code: 0xC02020A1 Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: Data conversion failed. The data conversion for column "Column 4" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". End Error
Error: 2016-07-26 05:02:01.10 Code: 0xC020902A Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: The "Source - Serve_Me_incidents_csv.Out puts[Flat File Source Output].Columns[Column 4]" failed because truncation occurred, and the truncation row disposition on "Source - Serve_Me_incidents_csv.Out puts[Flat File Source Output].Columns[Column 4]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error
Error: 2016-07-26 05:02:01.10 Code: 0xC0202092 Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: An error occurred while processing file "C:\Extracts\ServeMe_CSV\i ncidents.c sv" on data row 537. End Error
So, Column 4 and line 537 are the things that stick out to me.
Line 537:
Data Conversion:
Destination Table:
My Investigations:
Line 537 column 4 is Russian text - could this be the issue its failing?
The destination table is set to a varchar(max) and the dataconversion is set to string(847) so it cannot be anything to do with the length of the string.
Confused! Hope someone can help.
I have a very problematic SSIS package that uploads data from a CSV file to an SQL table.
Its working most of the time but is failing every so often and its obvious that its an issue with the CSV file data.
The errors are:
Message
Error: 2016-07-26 05:02:01.09 Code: 0xC02020A1 Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: Data conversion failed. The data conversion for column "Column 4" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". End Error
Error: 2016-07-26 05:02:01.10 Code: 0xC020902A Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: The "Source - Serve_Me_incidents_csv.Out
Error: 2016-07-26 05:02:01.10 Code: 0xC0202092 Source: Data Flow Task 1 Source - Serve_Me_incidents_csv [571] Description: An error occurred while processing file "C:\Extracts\ServeMe_CSV\i
So, Column 4 and line 537 are the things that stick out to me.
Line 537:
Data Conversion:
Destination Table:
My Investigations:
Line 537 column 4 is Russian text - could this be the issue its failing?
The destination table is set to a varchar(max) and the dataconversion is set to string(847) so it cannot be anything to do with the length of the string.
Confused! Hope someone can help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the comments.
<Update>
I removed the row and re-run the job and it worked. I then tried just changing the russian text to "BLAH BLAH BLAH" and it also worked so i'm assuming it must be something to do with this text.
Today, a new CSV file has been generated and it failed once again due to the same issue.
Error:
(When opened in Notepad ++...)
(When opened in Excel...)
I'm really no expert when it comes to page encoding types or such but ...
Could it be the encoding of the CSV file?
Could it be that I have the incorrect code page setup for the file in the SSIS package? Is there a "catch all" code page?
<Update>
I removed the row and re-run the job and it worked. I then tried just changing the russian text to "BLAH BLAH BLAH" and it also worked so i'm assuming it must be something to do with this text.
Today, a new CSV file has been generated and it failed once again due to the same issue.
Error:
(When opened in Notepad ++...)
(When opened in Excel...)
I'm really no expert when it comes to page encoding types or such but ...
Could it be the encoding of the CSV file?
Could it be that I have the incorrect code page setup for the file in the SSIS package? Is there a "catch all" code page?
ASKER