August 11, 2015 at 5:49 pm
I have a SSIS package. Inside a data flow, I have an OLE DB Source that uses the "Oracle Provider for OLE DB" to connect to an Oracle db to retrieve data from an Oracle table. The result includes a number of VARCHAR2 columns and one BLOB column named "doc". When I execute the package in Visual Studio 2013, I got this error on the OLE DB Source:
[OLE DB Source [94]] Error: Failed to retrieve long data for column "doc".
And then some SSIS error code DTS_E_INDUCEDTRANSFORMAILUREONERROR and DTS_E_PRIMEOUTPUTFAILED
So basically, it fails to retrieve the BLOB column. However, if I run the package as a SQL agent job, it works just fine. It just does not work when I execute in the Visual Studio? Any ideas? Thanks.
August 13, 2015 at 7:41 am
Maybe you have to play with these 2 properties BLOBTempStoragePath and BufferTempStoragePath
Availabe at the Data Flow level
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply