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 |
|
namasteall2000
Starting Member
20 Posts |
 Posted - 2006-06-06 : 13:51:52
|
| Hi guys ,I have a question - I want to create a DTS package where I have two SQL - e.g 1- Select top 10 orderid from Order 2- Select top 10 Customerid from CustomerAnd I want first result set to go on the first tab in the spreadhseet Excel and second result set will go to second tab of the same worksheet. I know how to tyransfer data to different work sheets but not able to even guess how to have two transformation hitting to the same spreadsheet but different columns.Above written Queries are just exapmples.Does anyone has idea if this is possible in DTS package or not? And if yes then how?Thanks in advance. |
|
|
|
|
|
Transferring data in the excel on diff tabs