I appreciate the comments but nothing is working. When I use the SQL Server Manager to Import the data from Oracle it works fine with no errors. ...

Here is the entire query. It is basically the lines with the word description that are causing the problem in SSIS. Thanks

select c2.inventoryid,

CASE WHEN i.accepted = 0 THEN...

In PL SQL Developer I can see that the case is lower and when I run the query in PL SQL Developer it runs fine. When I use the...