Instead of .NET sql bulk copy, is it possible with Stored-Procedure?

[fletchsod]

Hi!

I've been writing the .NET application/window-service to start using bulk copy instead of line-by-line sql insertion, when reading from text file. It works pretty fast and beautifully.

Now I'm wondering if it can be done with the .NET script to do bulk stored-procedures? If so, what .NET object does those? I haven't found one that does this.

Thanks...

 

[jmeckley]

if works fast and beautifully, why change it?

2nd a stored proc is just executable sql statements (similar to ado.net command text). you can use a proc to kick of a DTS/SSIS package which can preform the ETL (extract, transform, load) for you, but this is redundant.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[fletchsod]

I have 5 applications/window-services that read from text file. I just converted 4 of them to use bulk copy.

The 5th application/window-service is what I'm working on right now, it read data line-by-line, for each line it called the stored-procedure. The script inside stored-procedure manipulate the data further before inserting to database.

Since the bulk copy works, (read line-by-line to dataset then bulk copy to database) so I figure there should be one for stored-procedure for bulk copy for quicker processing time.

DTS/SSIS package is too much trouble cuz it can't do a few things for our need. Oh well.

Thanks...

 

[jmeckley]

check out rhino.etl. simple and easy to use. good references online too.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259