How can I goto ActiveX module XYZ?
-
I've got several ActiveX modules in a package and want to return to a previous ActiveX routine. How can I return back to like step 1 or 2 ActiveX?
-
You can't. That would create a circular preference. Step 1 wouldn't be able to run unless step 6 failed, but step 6 won't run unless steps 1 through 5 are successful. See what I mean?
Are you trying to re-run the whole package or just the one Active X module? You can copy the activeX module and paste it in as a new module and add that to another point in the precedence.
My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url] -
Well, you can - sort of. You can do looping using ActiveX script to play with the status of the steps. Check out or http://www.sqldts.com/?246 for a good example. If you can restate your problem as one that decides whether or not to "restart" from a previous step, you can use this technique.
Larry
Larry
-
Yep, this is it.
It seems pretty messy, perhaps I don't understand it that well. Time to dig through BOL and study this in my sleep.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply