I' am importing jpg-files into a SQL2K database.

Currently I am using a staging table in wich I import the jpg's using
textcopy.
(first create the records with a placeholder in the image-field, then import
the jpg using textcopy)

Then I use a stored procedure in wich I make alle the necessary
Inserts/updates.

All this is done through a DTS.

(in the same dts I import/process also other data related to the pictures)

Is there a better way using DTS to import the pictures into a SQL2K database ?

How to perform a Read File transformation (Enterprise Manager)
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\ho
wtosql.chm::/ht_dts_trns_2yem.htm)

Read File Transformation
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\dt
ssql.chm::/dts_elemtr3_86cu.htm)

Read File Transformation
(http://www.sqldts.com/default.aspx?304)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

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