Exporting file-data from a table in SQL2000

#1

We have a database where one table contains the file-data for documents.

The table contains:
filename of datatype nvarchar(2000)
filedata of datatype image(16)

What I want to do is to export the files to regular files. So a file in
SQL2000 becomes a file in the filesystem with the name of "filename".

Is this possible? How?

--
_________________
Rolf @ Questus ans

#2

Hello Rolf,

Does this article help?

http://www.sqldts.com/default.aspx?294

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

We have a database where one table contains the file-data for
documents.

The table contains:
filename of datatype nvarchar(2000)
filedata of datatype image(16)
What I want to do is to export the files to regular files. So a file
in SQL2000 becomes a file in the filesystem with the name of
"filename".

Is this possible? How?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Exporting file-data from a table in SQL2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Exporting file-data from a table in SQL2000 - 02-12-2006 , 09:46 AM

Re: Exporting file-data from a table in SQL2000 - 02-12-2006 , 09:52 AM