Passing Images to WebService method vis SSIS Package - issue with GetBlobData method

• Gunjan

  Hall of Fame

  Points: 3226

  More actions

  June 15, 2012 at 8:57 am

  #392535

  Hi,

  I'm designing a package which should read the image column from the database and pass the image to webservice method.

  I'm using the OLE DB as a source followed by/connected to script component which converts the image column (which is a type of BLOB) to a byte array. as shown below:

  Microsoft.SqlServer.Dts.Pipeline.BlobColumn objFaxImage = Row.Image;

  byte[] faxImage = objFaxImage.GetBlobData(0,(int)(objFaxImage.Length));

  objResMsg = objFaxComSVC.WebMethod("file", faxImage); //Webservice Call

  The code in the script works fine until it gets to one of these very large parameter sets. I have figured out what is causing the issue. Here's some code:

  byte[] faxImage = objFaxImage.GetBlobData(0,(int)(objFaxImage.Length));

  The second parameter of the .GetBlobData function takes an INTEGER as its count! Therefore, it will be limited to 32767 characters and it'll truncate the image.

  THIS IS A PROBLEM!!!

  Does anyone know a workaround for this issue?

  Not sure if there is any other way to perform this.

  My development environment is BIDS 2008.

  Thanks in advance.

  Thanks.

  Gunjan.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 3, 2012 at 10:48 am

  #1508340

  I don't think an integer is anywhere near that small, see: http://vb.net-informations.com/language/vb.net_data_types.htm

  CEWII