Post reply

SSIS Varbinary Datatype Problem

  • May 11, 2010 at 7:05 am

    #140081

    Hi,

    I am using SSIS package to Transfer varbinary Data to different servers.

    In source table i have Image in varbinary(max) Column.

    I have Mapped columns properly with distination table.

    In few rows the varbinary data not get transfered it has blank data and my package not giving any error.

    May be the problem is size of image which i am saving in varbinary(max) column.

    Please see SSIS_image1 is my Destination table and SSIS_image2 is my Source table screenshots.

    Source Table

    Destination Table

    In LOCAL LAN network it works fine when i am transfer over the internet my data got missed in destination table.

    Please help me into this i dont know how can i solve this problem?

  • May 14, 2010 at 1:45 am

    #1167339

    No body is looking on my question??? :O

  • May 14, 2010 at 2:18 am

    #1167351

    The size of the varbinary(max) should be no problem, as varbinary(max) allows up to 2^31-1 bytes. (see http://msdn.microsoft.com/en-us/library/ms188362.aspx). MSDN even says that varbinary(max) is suffice for a replacement of the image data type.

    Maybe there is some option in SQL server that dictates that a particular row/column can't take more than x megabytes?

    Or the firewall stops you from transferring such big data volumes?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 14, 2010 at 2:32 am

    #1167359

    Thanks for ur concern.

    Actually SQL showing it blank in Recordset on Analyzer but it has exact record what i have sent from local server.

    I dont what stoping sql to show the data of large size though i can see small size data. please refer the images on 1st post.

  • May 14, 2010 at 3:17 am

    #1167383

    niteshkumar80 (5/14/2010)

    Thanks for ur concern.

    Actually SQL showing it blank in Recordset on Analyzer but it has exact record what i have sent from local server.

    I dont what stoping sql to show the data of large size though i can see small size data. please refer the images on 1st post.

    In SQL Server Management Studio there is an option that sets the amount of data that is shown in the results. (see screenshot in attachment). If you set it to a higher amount, you'll probably get all the results (slowly).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 14, 2010 at 6:13 am

    #1167459

    Hi,

    Its Set to Maximum at my end. :O

    Still no result.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply