Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help on importing file

Status
Not open for further replies.
denis60

denis60

Technical User
Apr 19, 2001
89
CA
Hi! everyone

I'm a newbe in SQL server 2000.
I need help on how could be the best way to transfer data (+10,000 lines) from a linux server to a SQL 2000 server (some codes would be appreciate).

Here the step i'm thinking about:
1- Server linux send each 10 minutes a text file with data for multiple table in a SQL 2000 directory.

2- The file is read from (bcp or bulk insert or dts?) to send the data to the good tables.

3- When done the text file is delete

Thanks in advenced
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
163
tekpr00
tekpr00
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
257
gk53
gk53
ChewDoggie
  • Locked
  • Question
Help with Select statement Substring
Replies
2
Views
172
ChewDoggie
ChewDoggie
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
204
drlex
drlex
JCAD1
  • Locked
  • Question
Very urgent help required
Replies
0
Views
151
JCAD1
JCAD1

Part and Inventory Search

Sponsor

Back
Top