Importing information from unix file to Database

[sgreenwest]

All,
I have been told I have to develop a system to that imports a UNIX text file periodically over the day into a SQL server Database. I am new to SQL server but can anyone give a pointer to what I will need to do to enable this to happen, the background to it is the file is sent out to a directory on a UNIX server where I will pick it up, parse and import into the database. I’m sure this has been done before so I want to make sure I start off along the correct lines. Any ideas pointer would be excellent.

Thanks In advance

 

[mrdenny]

DTS, bcp or bulk insert can all be easily used to import the file into the database.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[sgreenwest]

can i set it up so the sytem will check every few minutes if there is new information so in the location.

 

[mrdenny]

Yeah, just schedule a job to run the procedure every few minutes. Then process the data that is imported as needed.

Denny

--Anything is possible. All it takes is a little research. (Me)