Pattycake245
Programmer
Is it possible to use DTS and insert a text file into a table that has more columns than the text file? Or is it easier to just dump the file into a dummy table and then insert into the live table?
Tim
Tim
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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Inserting using DTS into table with more columns
- Thread starter Pattycake245
- Start date
- Status
mercwrought
Programmer
It is a piece of cake just makes sure that under transformation - column mapping you line up the source and destinations correctly.
- Status
Similar threads
- Locked
- Question
- Locked
- Question