If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Bulk Insert doubts

Hello Guys,

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.

Environment

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?