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

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<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|||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|||xp_cmdshell (I guess beer does make you lose brain cells)