Post reply

Extract image from xml and save as file

  • June 10, 2008 at 3:32 am

    #188739

    I have been tasked with taking an image from an xml file and saving it as a file. I have been unable to find any help on this. The rest of the file is being pulled into SQL Server. Will BCP work?

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • June 10, 2008 at 8:40 am

    #826702

    Sorted, bringing file into sql server as an image and extracting from here as a file.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • June 11, 2008 at 12:11 am

    #827070

    hi,

    you should create a new SSIS package and use Export Column component in the data flow tab

    to export the images to file.

    yoo can do it in one phase both to extrat to file and to SQL

    HTH,

    Yaron .

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

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