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

How can I attach the ASPNETDB mdf to SQL 2005?

I want to import a table and data in SQL 2005 to the table in the ASPNETDB mdf. Please help.

Do you know where the database is?

I would recommend you to read this series to get start. You will be there.

http://aspnet.4guysfromrolla.com/articles/040506-1.aspx

|||Dumb Questions...what do I type in to get here...navigate to%WINDOWS%\Microsoft.NET\Framework\v2.0.50727|||I figured that out. How do I runaspnet_regsql.exe|||double click on it.sql

How can I append only new rows in a table using SSIS?

Hi,

Im creatting an SSIS project that uses an Data Flow OLE DB Source to read data from an SQL Table and import it into a Destination table using Data Flow OLE DB Destination. but now everytime I run the project it appends all the rows not the new data rows only. How can I make the application so that it appends only the new data from a source table to a destination table. Is there maybe another Data Flow Control that can copy source table to destination and the next time it runs it only copy new rows. or any other way to do this using SSIS.

Your assistance will be highly appreciated.

Use the Lookup component. Set it up to return the keys of the destination table. Map the keys to your input data. Then grab the red arrow coming out of the lookup and hook it up to your destination.|||

Hi Phil,

Im new to SSIS, please bear with me. I have maped the lookup component to the destination table and hook the redline out of the lookup to destination OLE DB Destination which is also mapped to a destination table. It coppies all the rows.

Please email me the sample project, my email is sibu.khanyile@.enerserv.co.za

Thank you in advance

|||Make sure that you use a derived column to TRIM() the key fields going into the lookup component. Also know that the keys must have the same CaSE as those in the destination table in order to match.