help with procedure

[stanfran]

i am trying to write a procedure in transact-sql that will sweep through a directory of ascii files and import them into a table. The number of files and filenames are unknown. Any tips would be appreciated.

 

[TomSark]

I'm sure there are multiple ways to do this, but you could create a DTS package using VBScript that uses ADO to read the binary data into a recordset and then updates the SQL Server table.

And, thinking about it a little more... you might also experiment with using sp_oacreate to instantiate an ADO connection object and also a recordset object inside the proc and use the sp_oamethod calls to invoke the needed functionality within these objects. You should at least have MDAC 2.5 on your server 7.0 machine, therefore, the ADO objects will be available to you.

I know I'm not giving you a coded solution (time constrained), but this should get you started...

Hope this helps...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[foxdev]

There's an article here

http://www.swynk.com/friends/green/dtsdirloopstep.asp

that discusses how to do this with DTS. A very good article with samples.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org