all groups > sql server dts > march 2004 >
You're in the

sql server dts

group:

Export binary data to hard disk folder


Export binary data to hard disk folder East...
3/12/2004 8:56:09 AM
sql server dts: Hello People

I have began to store binary data in my database, for example word documents, PDF's....etc

But now my database file is growing beyond what I want, and I need to move all of the files out of the DB table and onto normal hard disk space

Is there anyway, say by using a bulk copy command or DTS, that I can write all the contents of the DB table and into a folder on my hard disk...??

My database table consists of ID(int), Filename(varchar), Filetype(varchar), Filesize(varchar), Filebody((image) - this is where the word,pdf, etc. file is stored

Any help would be extremely appreciated....

Many Thanks

Re: Export binary data to hard disk folder Darren Green
3/15/2004 8:34:02 PM
In message <C063A3FB-C6D8-4E49-9A45-270DE09D462C@microsoft.com>, East...
<alaneaston666@hotmail.com> writes
[quoted text, click to view]

Try this-

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

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
AddThis Social Bookmark Button