View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:49 PM
Greg D. Moore \(Strider\)
 
Posts: n/a
Default Re: Best way to import ASCII tab delimited file every week (5,000 records)...


<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
>
>



Reply With Quote