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 |
|
pizzazzz
Yak Posting Veteran
55 Posts |
 Posted - 2010-07-16 : 16:55:42
|
| I want to loop through the dataset and copy to a tab in excel (this i already have done)however - depending on a change to a value, start copying the next set of records to a new tab in Excel.the dataset contains products and the product manager associated to a group of products.the dataset is sorted by email address of the product manager. so all products by managers are in sequential order.when the email address changes start to copy(export) the records to a new tab in excel.eventually, I want to go straight to just emailing all the products to each Product manager for review.I could do this quickly in DTS packages but am new to SSIS and is seems to be a daunting task.any help I can find would be absolutely appreciated.thanks! |
|
|
|
|
|
How do you loop through a dataset.....