Post reply

Import/Export Pictures

  • May 16, 2007 at 12:28 pm

    #124058

    Does anyone know how to use the Import component of a Data Flow task to save a jpg file to a table in a column of datatype image? And then to use the Export component to write the file as a jpg for use?

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • May 16, 2007 at 1:11 pm

    #706925

    Well this problem turned out to be easier than the package variables problem; at least for me.

    The thing I couldn't find is that I had to create an import column output and then use the ID from that and put it in the import column imput to link the file path/name to the destination column.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

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

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