SEO

#1 (**permalink**) 02-28-2008, 06:49 PM

I need to import an ASCII tab delimited file that has roughly 5,000 records
once a week into a SQL Server table. I have researched BCP and it seems
like the way to go. Am I headed in the right direction?

Thanks in advance,

James

#2 (**permalink**) 02-28-2008, 06:49 PM

<JFOREMAN10@houston.rr.com> wrote in message
news:Xlstb.75400$KY1.58889@twister.austin.rr.com.. .
> I need to import an ASCII tab delimited file that has roughly 5,000
records
> once a week into a SQL Server table. I have researched BCP and it seems
> like the way to go. Am I headed in the right direction?

It is certainly one way to go. The other is to set up a DTS job. I'd
probably use that since it's the more "modern" way of doing it from within
the DB.

>
>
> Thanks in advance,
>
>
> James
>
>

#3 (**permalink**) 02-28-2008, 06:49 PM

Another option is write a stored procedure that uses Bulk Insert. And
schedule the stored procedure as a SQL Agent Job. (BCP runs on the
command line. So you can also write a stored procedure that uses
xp_commandshell to pass to BCP). - Louis

#4 (**permalink**) 02-28-2008, 06:49 PM

xp_cmdshell (I guess beer does make you lose brain cells)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Best way to import ASCII tab delimited file every week (5,000 records)...