SSIS package failure message
Home > IT Answers > SQL Server > SSIS package failure message
MarkFyffe
5 pts.
0
Q:
SSIS package failure message
SQL Server 2005, SQL Server errors, SSIS
I am running SQL Server 2005 and my package fails with the following error:

OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

I have checked 2 items number 1 I looked at the source column which was data type nvarchar(128) and the destination converted column which was string[DT_STR] (50) I changed it to string[DT_STR] (128) this didn't help. I looked at the values in the fields and removed all spaces and suspicious characters i.e. "-" but that didn't help either.

Any suggestions out there?
ASKED: Sep 23 2008  1:58 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I assume you are getting this from the data conversation task? If your source column in nvarchar then you need to use a uni-code data type from the source. The source should be "Unicode string DT_WSTR". If the data is actually uni-code then you will want to change the destination to a uni-code datatype as well.
Last Answered: Sep 28 2008  5:13 AM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0