
September 2nd, 2006, 03:20 PM
|
|
Registered User
|
|
Join Date: Sep 2006
Posts: 1
Time spent in forums: 24 m
Reputation Power: 0
|
|
|
Need help building a DTS package
Hi,
I'm looking to make a DTS package which will work with two tables to print out an XLS report. I have a table with leads and one with returns, the returns table will contain rows which do not exist in the leads table. These two tables can be joined on a specific column, I want the dts to perform the inner join on the columns on each table, then create an XLS sheet in which it will dump rows that exist in the leads table but not the return table. How would I go about doing this? and please, be specific....
Oh, and I'm using sql 2000, so there might be limitations.
-Thanks
|