SQL Server Performance

SSIS Error: Text was truncated or one or more characters had no match in the target code page

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 29, 2007.

  1. Anonymous New Member

    This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Then the string MM/DD/YYYY is converted to a date in a Data Conversion flow. And finally the data is put into a SQL Server table (currently with no rows). There is a temparory table involved here to import rows and then eventually the relevant...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/29/ssis-error-text-was-truncated-or-one-or-more-characters-had-no-match-in-the-target-code-page.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1774" width="1" height="1">

Share This Page