How can I declare a variable in SSIS 2008 package with data type varbinary(max)?
How can I declare a variable in SSIS 2008 package with data type varbinary(max)? Thanks.
June 27th, 2011 9:52pm

Please check here for sample http://jahaines.blogspot.com/2009/10/ssis-importing-binary-files-into.htmlhttp://uk.linkedin.com/in/ramjaddu
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2011 10:00pm

SSIS 2008 package with data type varbinary(max) varbinary(max) belongs to SQL Server 2005 and up implementation, it is not part of ETL that needs to work with all sorts of databases. use DT_BYTES in your package. Source: SSIS Data Types Reference with mapping http://msdn.microsoft.com/en-us/library/ms141036.aspxArthur My Blog
June 27th, 2011 10:02pm

SSIS 2008 package with data type varbinary(max) varbinary(max) belongs to SQL Server 2005 and up implementation, it is not part of ETL that needs to work with all sorts of databases. use DT_BYTES in your package. Source: SSIS Data Types Reference with mapping http://msdn.microsoft.com/en-us/library/ms141036.aspx Arthur My Blog I am using OLE DB Source to run sql command. The output column (DocumentBinary) is set to DT_Bytes. 1. How to know what length to set for DT_Bytes. It is currently showing 50 by default, but that seems to be small. 2. When I run this package I get error: Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Source" (128) failed the pre-execute phase and returned error code 0xC0202009. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E07 Description: "Error converting data type varchar to int.". I don't know what varchar to int is it encountering. my source column is varbinary(max) which I am trying to extract in DT_Bytes. Thanks.
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2011 10:33pm

Please check here for sample http://jahaines.blogspot.com/2009/10/ssis-importing-binary-files-into.html http://uk.linkedin.com/in/ramjaddu checked the sample, but did not find a sample where it handles varbinary(max) in the ssis package. Thanks.
June 27th, 2011 10:35pm

use the DT_IMAGE data type then insteadArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2011 10:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics