I don't see a forum for SSIS 2008, so I guess I will post here??
I have an OLE DB connection to an IBM DB2 source. I am trying to bring in some data from a query on a few tables. One of the fields I am trying to import is defined as a CHARACTER with a length 70.
When I run the package, I get the following errors:
[OLE DB Source ] Error: There was an error with output column "CC_COMMENT" (743) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
[OLE DB Source ] Error: The "output column "CC_COMMENT" (743)" failed because truncation occurred, and the truncation row disposition on "output column "CC_COMMENT" (743)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
I have tried adding a Data Conversion and converting to both DT_STR and DT_WSTR with Lengths of 70 and 255.
I have tried inserting into both a varchar(max) field as well as a char(255) and an nvarchar(max)
In every case, it fails.
Any ideas? It makes we wonder if there is some kind of wonky character in the field somewhere, hence the "no match on the code page".
SSIS quite often seems to use a default width of 50 for strings.
Try opening up the advanced editor for your datasource and looking at the suspect column data types there. The error is happening before you can possibly fix it using data conversions - it's happening right at the start of your data pipeline.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.