July 22, 2010 at 12:21 am
Hi
I was trying to import Pdf files into SQL server table using Import Column and OLE DB command transformations and i am getting following error.
Coulmns data type used in table : Filepath : varchar(50), Pdf : Binary(250)
[OLE DB Command [50]] Error: There was an error with input column "pdf" (72) on input "OLE DB Command Input" (55). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
[OLE DB Command [50]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Command Input" (55)" failed because error code 0xC020906D occurred, and the error row disposition on "input "OLE DB Command Input" (55)" 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.
Could anyone help me in rectifying the error.
Thanking you
Ram
July 22, 2010 at 12:34 am
INDUCEDTRANSFORMFAILUREONERROR itself says that pdf can't be imported.
July 22, 2010 at 12:39 am
Hi
It means Pdf of particular format cant be induced into table, do i need to use any data conversion transformation. Could you kindly let me know if there is any solution.
Cheers
Ram
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply