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 |
|
srxr9
Starting Member
15 Posts |
 Posted - 2006-10-06 : 12:19:28
|
| I have a DTS package that is scheduled to run everyday.It gets the global variables from a table based on the processing day for a client. Every client in the table has a processing day. So the DTS package will get the clientID and other attributes as a Global variable, when the package run day = processing day.Problem arises when there are two clients with same processing day. DTS pacakage runs for only one client and stops.What is the best way to handle this situation? Meaning how to make the DTS package to run for both the clients if they have the same processing day.Any advice will be helpful.ThanksSuresh |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-10-09 : 15:32:21
|
| You need to loop through all the rows with a particular date. Have a look at the following link [url]http://www.sqldts.com/default.aspx?246[/url] for an explanation of looping in DTS. You're probably best off separating out your package into one master package that gets the recordset for a particular day and performs the looping, and another child package that receives the global variables from the other package and actually does stuff.Mark |
 |
|
|
|
|
|
Question regarding DTS package