Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: DTS Packages and Image/Binary/Blob data

    I am trying to build a DTS pacakage that will create the database structure our application uses for our clients. The biggest problem I am having is when it comes to the reports, which we've stored as Image data in the database. During run time we get chunks to get the report out of the database. Has anyone tried and been successfull as using a DTS package to load binary/image data into a SQL table? My preference would be to use a global variable in the package to hold the location where the files are stored, and have them pulled in to their respective tables & fields when the package runs.
    Any one have any ideas?
    I've tried several resources, with no luck.

  2. #2
    Join Date
    Aug 2002

    Exclamation Use textcopy.exe to insert binary data

    Look for textcopy.exe on the web. Call a procedure from your DTS Package that will execute the following :

    EXEC master.dbo.xp_cmdshell 'textcopy.exe -S ' + @srvname +
    ' -U ' + @login +
    ' -P ' + @password +
    ' -D ' + @dbname +
    ' -T ' + @tbname +
    ' -C ' + @colname +
    ' -W "' + @whereclause +
    '" -F "' + @filename +
    '" -' + @direction


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts