December 12, 2006 at 12:36 pm
I have written many DTS packages to move data, however, I have never had to use parameters.
I'm creating a package which has a log table. It runs four times a day. It will check the log table, if the package has already run, stop. If it hasn't run, go on with further processing.
I've create three SQL Tasks
Task 1 - check table. Initialize parameter.
Task 2a - If Task 1 has not run, continue with process and query additional table.
Task 2b - If Task 1 has run, Update batch control table and stop.
So far, I have created my output variable and mapped it to a global variable. Now how do I use that global variable to know to know where to go to after task 1?
Task 1
Task 2a Task 2b
Thanks!
Tony
Things will work out. Get back up, change some parameters and recode.
December 12, 2006 at 2:23 pm
http://www.sqldts.com/default.aspx?234
http://www.sqldts.com/default.aspx?205
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply