Forum Discussion

Sky_River's avatar
Sky_River
Copper Contributor
Sep 12, 2023

Import Oracle "BINARY FILE LOB" to SQL Server

I can see the image from Oracle SQLDeveloper, but not able to import to SQL Server. SQL Server Import and Export Wizard auto changed the "BINARY FILE LOB" to [varbinary](max)


- Copying to [myschema].[mytable] (Error)
Messages
Error 0x80004005: Data Flow Task 1: (SQL Server Import and Export Wizard)

Error 0xc0208265: Data Flow Task 1: Failed to retrieve long data for column "DOCUMENT_BFILE".
(SQL Server Import and Export Wizard)

Error 0xc020901c: Data Flow Task 1: There was an error with Source - mytable.Outputs[OLE DB Source Output].Columns[DOCUMENT_BFILE] on Source - mytable.Outputs[OLE DB Source Output]. The column status returned was: "DBSTATUS_UNAVAILABLE".
(SQL Server Import and Export Wizard)

Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Source - mytable.Outputs[OLE DB Source Output].Columns[DOCUMENT_BFILE]" failed because error code 0xC0209071 occurred, and the error row disposition on "Source - mytable.Outputs[OLE DB Source Output].Columns[DOCUMENT_BFILE]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source - mytable returned error code 0xC0209029. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

 

please help,

 

many thanks

SkyRiver

No RepliesBe the first to reply

Resources