How to Combine Two Tables

Question

How to Combine Two Tables

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bill Geake Ten Centuries Points: 1352 More actions · Answer 1

If I understand it correctly, you want to retrieve certain records from the second flat file and append them to the table populated from the first file.

I would:

Build a table to load the second flat file into
Have a transformation task which loads this data from the file as-is
Write a stored procedure to return the desired records from the new table
Have a second transformation task which uses the stored procedure as a source and the existing table as the destination. This would deal with the missing / out of order columns.
Schedule by right-clicking the DTS package in Enterprise manager. Then go to SQL Server Agent in EM to adjust the new job as needed.

HTH

Bill.

Will Strohl SSC Rookie Points: 34 More actions · Answer 2

Thank you for your reply. Through much trial and error yesterday, I eventually did something very similar to what you suggested. However, I have it all in a single DTS package.Thank you so much for your reply.

amackay_1 Ten Centuries Points: 1240 More actions · Answer 3

Books Online is a pretty good source of DTS information. Search under "DTS, transformation issues" to get some specifics to watch for when setting up your process.