December 31, 2009 at 6:21 am
Hi,
I'm trying to extract data from a proprietary db using SSIS. I've set up an ADO .NET odbc connection and have a DataReader Source that connects to a target table via an OLE DB Destination and can get INT values and even dates etc. Trying to grab a simple varchar doesn't work though. SSIS sets the column as DT_WSTR (a unicode string) but when the package is run the DataReader Source turns yellow and never does anything - or if a I use a Script Component to send the values to, the DataReader Source gives a DTS_E_INDUCEDTRANSFORMFAILUREONERROR error naming the varchar column.
Any suggestions greatly appreciated.
December 31, 2009 at 10:42 am
Did you try setting the destination column to nvarchar?
January 3, 2010 at 1:16 pm
The destination column in the target table is nvarchar. I can't see anywhere else to define the type other that in the DataReader Source where changes have had no positive effect.
January 4, 2010 at 7:59 am
Doh!
This now looks like a desktop issue. I tried using the dev server itself to create the package and everything runs smoothly from there. The server was using .NET framework 2 whereas my pc was on .NET 2 SP2 - but removing this and installing plain 2 did not resolve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply