sql server dts: is it possible to export blob data from a database using the DTS.

What about

Write File Transformation
(http://www.sqldts.com/default.aspx?294)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
export these using the dts and have then be saved as an external file. Is
this possible?

You can use the TextCopy exe which is in your Binn directory

http://www.allisonmitchell.com/Articles/TextCopy.htm


You can also use the Stream Object in a piece of VBScript.





--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
the fly without forcing it to be a field in the source table?