Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-02-22 : 09:06:40
|
| hi I have a slight confusion as to how to design this packageI have an excel sheet that needs to be compared against a table in an SQL server database & give the output in excel file which should get mailed as an attachment Can anyone plz help me with this, am trying out a lot of things but cant actually figure it outthanks in advanceRegardsKid |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-02-22 : 10:54:54
|
| 1. load excel into work table in sql.2. compare with existing data3. output results to excel4. call sp_sendmail or (xp_sendmail) with results.get each stage working on it's own....and then put together. |
 |
|
|
|
|
|
DTS Package confusion