Post reply

downloading files in db tables

  • April 6, 2009 at 2:02 pm

    #207983

    I have a table that I created and an app that allows me to upload files into the table, storing the docs in an image column and the filename in a varchar.

    I'd like to be able to grab all the docs out of here and put them into a file system instead. Is there a fast way of doing this in SQL, or do I need to write code to download each file?

  • April 7, 2009 at 1:02 pm

    #973733

    You wont find any stock components in 2005 to write image files out directly using T-SQL. My suggestion would be .NET code or use of SSIS. SSIS has an import/export component that you could use with a for loop over the record set to create an output to disk of all the binary files in the db.

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

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