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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Compare Global variables, make decision

Author  Topic 

ComputerMike
Starting Member

18 Posts

Posted - 2007-12-10 : 11:53:55
I have two global variables in my package. They are dates. If the dates are the different I would like to execute rest of package, if they are the same I would exit the package.

I.E. in VB

If Date1 <> Date2 then
run_rest_of_package
Else End If

I am trying to figure out how to do this. I think I would create an Active X script, compare variables and set step success or failer, but need a little help.

Thanks,

Mike

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2007-12-19 : 14:23:53
yes activex would be fine.

See the example below as to how to access global variables and how to mark a task as a success or a failure.

http://www.sqldts.com/298.aspx
Go to Top of Page
   

- Advertisement -