How can I automate importing tab delimited file into SQL Server?

Hi,
We import data from our phone system every morning which is a tab delimited
file. I'd like to automate this process. I'd appreciate some pointers on thi
s.
Thanks,
SamThere are a few methods to do this, such as DTS, BULK INSERT or BCP. The
basic pattern is to import into a staging table, validate/scrub and then
insert the new/changed data into your permanent table.
The default text file format for BULK INSERT and BCP is tab-delimited,
carriage-return/line-feed terminated so you can probably import without a
format file as long as your target table matches the fields in the files.
My personal preference would be to use DTS for this task.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:29C44B40-6625-48DE-90DF-BAF7FBA6EB76@.microsoft.com...
> Hi,
> We import data from our phone system every morning which is a tab
> delimited
> file. I'd like to automate this process. I'd appreciate some pointers on
> this.
> --
> Thanks,
> Sam