soon soon, í´ll have to devellop some procedures to read an ASCII file to supply MS SQL tables. As I´ve read some old post, I´ve understand that I have to use BULK INSERT , or else, BCP or DTS. I´d like to know the diference between this commands and witch of them is more powerful, faster and efficient. If you can give me some implementation tips, I will be very grateful.
Well thanx for all replies... Talking about what I have... I´ll have 30 ASCII files to load as I told you, and approximatly 91292,42 KB for each... It´ll run in production environment, to synchronize the ambient for a BI system... Which comand should I use?
Originally posted by Brett Kaiser
Did you look it up in BOL....
How is the data stored?
anyway...I almost exclusivley use bcp for Production code
BULK INSERT usually for quick data analysis..
and DTS for analysis, if the data is in Excel, Access, whatever...