The Execute SQL Task

Question

Post reply

The Execute SQL Task

Andy Leonard

SSChampion

Points: 10144
More actions
January 4, 2011 at 11:12 pm

#388553

Comments posted to this topic are about the item The Execute SQL Task
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 1

Carlo Romagnano

SSC-Insane

Points: 22669

January 5, 2011 at 12:49 am

#1269315

Easy question, when the luck helps.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 3

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.

WayneS SSC Guru Points: 95460 More actions · Answer 4

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 6

ForceExecutionResult is a great little debugging tool/task property. Great question.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

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

Andy Leonard SSChampion Points: 10144 More actions · Answer 9

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

cengland0 SSCertifiable Points: 6102 More actions · Answer 10

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.

UMG Developer SSChampion Points: 13482 More actions · Answer 11

UMG Developer

SSChampion

Points: 13482

January 6, 2011 at 10:45 am

#1270205

Thanks for the question!