Thanks Phil, This is inline with what I was thinking to do, I was hoping for an easy way but at least this confirms my approach is sound.

Cheers,

Mark

Hi Phil,

Thanks for your responses the following is the resolution to my connectivity issue with some additional details.

The Oracle Client was not installed on my machine.  After installing the 32...

Thanks very much for your response, and yes it works in SQL Server Management Studio with SQL authentication under same user and context. I haven't used any expression or...

Elliot thanks for your response you must have been typing the same time as me. I essentially did the same thing as you but instead of fixing everything after...

Thanks Grant for your response I know my problem was a little hard to understand but I appreciate your response. My data that is being looked up is fairly...

ok when I attempt this the system throws an error before execution in the design editor (big red X) saying basically myfield cannot convert between unicode and nonunicode data types.

My...

hey Koen thanks for your response just to be clear when you say set the input column to a string length of 1. Are you referring to the tab input...

Sorry replied to quickly I cast the object in the ole db source t-sql script and also the DB table is set to nvarchar(1)

In the database table

Yes everything is set to redirect row in the source component.

Thanks Koen for your response and yes my apologize this is a SSIS related question.

I tried your suggestion of pushing a larger string in a smaller string field i.e. Abbbb...

Thanks for the help Elliot I have passed this question on to the client's DBA as I am at a loss I will pass this info onto him if he...

Are the systems patched to the same level and the same version? Are the MSXML libraries installed?

The MSXML library was the first thing I tried so I installed the MSXML...

Hey Guys,

I need to revisit this issue. I have copied my solution and transferred it over to my dev machine via usb. when I open the solution I...