is it possible to export blob data from a database using the DTS.

I have a table with two relatively small blob fields. I would like to export these using the dts and have then be saved as an external file. Is this possible?

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


"Russ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

this possible?

Thanks, works just fine, but is there a way to increment the file name on the fly without forcing it to be a field in the source table?

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


"Russ" <anonymous (AT) discussions (DOT) microsoft.com> wrote