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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Automate Data Import?

Status
Not open for further replies.
Transform

Transform

Programmer
Feb 12, 2001
1
CA
Hi,

I'm new to SQL and I need help automating imports.
These are text delimited fields which will be appended to exiting tables. A trigger file will be sent to initiate the process.

Thanks in advance!
 
Sort by date Sort by votes
you can create a DTS import package and get vb code which can be called when the trigger is fired..

hope this helps
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
439
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
290
Andrzejek
Andrzejek
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
300
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
334
BobSuruncle
BobSuruncle
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
375
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top