<div>
<div class="content wysiwyg-content">
I'm importing data from as400 to sql 2005 using ibm db2 udb for iseries ibmda400 ole db provider. &nbsp;My problem is when users copy and paste text from email in outlook using html and paste it in the green screen, some type of formatting character is inserted also. &nbsp;The 400 ignores it but as I'm importing the data to the sql server it errors with error below. &nbsp;<br />

<pre><code id="code-273166">Error 0xc020901c: Data Flow Task: There was an error with output column &quot;DOMNOTES&quot; (17) on output &quot;OLE DB Source Output&quot; (11). The column status returned was: &quot;Text was truncated or one or more characters had no match in the target code page.&quot;.
</code></pre>
</div>
</div>


I'm importing data from as400 to sql 2005 using ibm db2 udb for iseries ibmda400 ole db provider.  My problem is when users copy and paste text from email in outlook using html and paste it in the green screen, some type of formatting character is inserted also.  The 400 ignores it but as I'm importing the data to the sql server it errors with error below.  

Import data from as400 to sql server 2005

I&amp;#39;m importing data from as400 to sql 2005 using ibm db2 udb for iseries ibmda400 ole db provider.  My problem is when users copy and paste text from email in outlook using html and paste it in the green screen, some type of formatting character is inserted also.  The 400 ignores it but as I&amp;#39;m importing the data to the sql server it errors with error below.  

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.