Home Forums SQL Server 2005 SQL Server 2005 General Discussion Write blob field to Windows File system RE: Write blob field to Windows File system

  • September 20, 2010 at 11:24 am

    #1224226

    The best I can think of is to use SSIS to write the object to a new file. I haven't done it before, but I'm guessing you'll need an OLE DB connection manager, a File connection manager, a DataFlow Task, and then the source and destinations.

    Beyond that, I'm only guessing. You'd have to play with it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.