Post reply

Extract Image object

  • April 8, 2008 at 5:22 am

    #188976

    Hello guys,

    In one of the proejcts, we have a table with one column of the data type image. Developers uploading files (.txt,.xls,.doc etc..) directly into sql server. That means SQL Server is holding the these uploaded files as records in the table. now these files are being extracted to a predefined directory on the DB Server using a DTS package. they have used fso ( file system objects) in activeX script inside the DTS for file extraction.

    Now, the question is..can i extract the file which is stored in that table to the physical directory without using DTS???

    (Usage of extrended stored procs permitted). Please let me know if any SP / Exteneded SP available for achieving this functionality??

    Thanks

    Raj

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • April 8, 2008 at 8:19 am

    #799769

    Dear experts..can any one please give direction to this problem?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • April 8, 2008 at 9:04 am

    #799823

    No, SQL Server isn't really built to write it's data to the file system. It writes it out to a client that can be used to build a file, display it, etc.

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

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