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!

Import Source File Name with every record. How?

Status
Not open for further replies.
natha

natha

Programmer
Nov 23, 2001
11
0
0
BE
I'm am using DTS for importing multiple txt files from a certain directory (as described here:
How could I also import for every record the name of the source file it comes from?

The import is being done to a SQL server table where I will add a varchar column, let's say, 'Source'.

Thx in advance...
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
64
tekpr00
tekpr00
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
100
gk53
gk53
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
77
drlex
drlex
ChewDoggie
  • Locked
  • Question
Help with Select statement Substring
Replies
2
Views
72
ChewDoggie
ChewDoggie
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
87
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top