hello,
i am trying to figure out how to check for failure or success AFTER the script task has ran.
its a piece of cake to write script logic that runs before the task but how do i check things and decide to retry AFTER a script task has ran?
i want to check for an error after a large table replication and if it detects that there was an error i want to RETRY.
dts does not seem to have this one specific piece of functionality. am i overlooking something?alright... i am closer to figuring this out although the solution seems a bit complex.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6196&pg=2
the WROX book that i bought on DTS "DOES NOT EVEN COVER THIS TOPIC" . it covers reactive error handling but doesn't say a word about proactive error handling.
i have a java programming background. can anyone see this from my point of view and give me a hint?
this reminds me of using the "onStart" and "onLoad" methods of ASP programming but it doesn't seem to be quite as simple to use...
Showing posts with label logic. Show all posts
Showing posts with label logic. Show all posts
Monday, March 19, 2012
Subscribe to:
Posts (Atom)