sql server new users: I am trying to figure out how to export a table of images stored on a SQL
2005 database to a directory on the local drive. In SQL 2000 one would use
DTS, but this does not seem to be the way to do it in 2005. Does anyone
happen to have a T-SQL script or maybe an explanation on how to do this in
2005? Is it done with the bcp command?


While I have looked at examples of using the bcp command to export data to a
file, it didn't look quite right for what I was trying to do.

Thanks for the advice.

Hi,

You might want to check the following articles:

http://www.codeproject.com/cs/database/FileStore2DataBase.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;317016

Jonathan



[quoted text, click to view]