The Execute SQL Task
-
Comments posted to this topic are about the item The Execute SQL Task
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics
-
Easy question, when the luck helps.
-
Another great SSIS question Andy!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
A helpful question, considering that I am currently learning SSIS. I don't know if I will need this trick, but at least I know it exists.
-
I'm a bit curious - when would you have a condition where you want the task to report as successfully completed when it actually failed?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
WayneS (1/5/2011)
I'm a bit curious - when would you have a condition where you want the task to report as successfully completed when it actually failed?To play April Fools tricks with your co-workers of course!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
ForceExecutionResult is a great little debugging tool/task property. Great question.
-
Daniel Bowlin (1/5/2011)
ForceExecutionResult is a great little debugging tool/task property. Great question.Indeed. I was just realizing that this property is ideal for testing event handlers, transactions and checkpoints in SSIS.
Usually I introduced some sort of error in the package, but this property is much easier.
All those things Andy can teach us with one simple question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Nice question - thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
WayneS (1/5/2011)
I'm a bit curious - when would you have a condition where you want the task to report as successfully completed when it actually failed?Hi Wayne,
I use it for testing fault tolerance, logging, and event handling.
:{> Andy
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics
-
This was a very easy question but when I saw it was worth 2 points, I had to hesitate before answering it and look through all the options a second and third time looking for a trick of some sort.
-
Thanks for the question!
Viewing 12 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply