September 23, 2010 at 8:27 am
Hi,
I want to import the data from a flat file to the Sql Server 2005 database.
I am getting the following after execution.
[Acct_Template [1]] Error: Data conversion failed. The data conversion for column ""Account Type"" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Acct_Template [1]] Error: The "output column ""Account Type"" (589)" failed because truncation occurred, and the truncation row disposition on "output column ""Account Type"" (589)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
I added a data conversion task between the flat file source and sql server destination.
In the data conversion task that column on which I am getting is defined as
Data Type: DT_STR
Length: 255
In the database the mapping column is defined as follows.
Data Type: varchar
Length: 255
Please help me to resolve this issue.
Thanks in advance.
September 23, 2010 at 10:12 am
What data type on the destination are you using? What code page are you using?
Assuming that you have checked for the max length of the column in your source, there is a good chance that there is data in your source that has a row with data outside the destination type or code page of your stream.
Either break your data down into smaller bits to troubleshoot, or put in some error handling that will route the problem row to a text file or something where you can take a closer look.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply