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)
