none
Can we use DTS to import PDF and MP3 into SQL Server 2000 table?

    Question

  • I've got a situation in whcih I have to import  PDF and MP3 files into SQL Server 2000 table.

    Thanks,

    YL
    Wednesday, August 30, 2006 6:34 PM

Answers

  • Store them as binaries using an image datatype in the table.  Look at this post for a good code example...

    http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=688850&SiteID=17

    Brad
    Thursday, September 14, 2006 8:01 PM

All replies

  • Any ideas?

    Thanks,
    Thursday, August 31, 2006 3:31 PM
  • Store them as binaries using an image datatype in the table.  Look at this post for a good code example...

    http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=688850&SiteID=17

    Brad
    Thursday, September 14, 2006 8:01 PM