On 05/10/00, ""meng jin yan" <jymeng@y...>" wrote:
> I want to load text file data into database. I found the interface for 
defining text file format provided by SQL Server Data Transformation 
Service is quite good and would like to have such a feature in my VB 
application. Unfortunately, I don't know how to implement it easily. Does
anybody know whether there is a component or DLL to let programmer to 
implement it ?

You can program DTS from a component, but I am not sure this is what you 
are trying to do. As far as BLOB data goes, you can store multiple types of 
docs in a database, along with a type (for searching since searching BLOBs 
not the best performance idea) and a doc name to save to, etc.

To use the SQL DTS DLLs, install SQL Server. The libraries are in RLL 
files, so I would not know how to register them otherwise.

GB