Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Import data from as400 to sql server 2005

Avatar of bergertime
bergertime asked on
Microsoft SQL ServerIBM System iMicrosoft SQL Server 2005
4 Comments1 Solution1232 ViewsLast Modified:
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.  
Error 0xc020901c: Data Flow Task: There was an error with output column "DOMNOTES" (17) 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.".
ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSPFlag of United States of America imageExpert for hire: IBM i, AIX, Linux, Windows, DB2, Performance, Security. EDI

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers