Import of image data

  • Can we import image data using DTS into a table? I need to test it for an application that uses these BLOB data.

    I have a table with a image data type column. I extracted the data from it and created a text file and imported it but got the error "During transformation 'AxScriptxform' scripting encountered run time error." Then I created an Excel file to import but same error.

    Any will be greatly appreciated.

    Thank you

  • SQL Resource Kit 2000 has got a tool called Bulk Image Insert (BII). Use that.


    -- Amit



    "There is no 'patch' for stupidity."



    Download the Updated SQL Server 2005 Books Online.

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

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