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