Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

The Execute SQL Task Expand / Collapse
Author
Message
Posted Tuesday, January 4, 2011 11:12 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
Comments posted to this topic are about the item The Execute SQL Task

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1042825
Posted Wednesday, January 5, 2011 12:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 2,469, Visits: 2,346
Easy question, when the luck helps.
Post #1042836
Posted Wednesday, January 5, 2011 1:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
Another great SSIS question Andy!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1042850
Posted Wednesday, January 5, 2011 6:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 3,447, Visits: 1,476
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.
Post #1043016
Posted Wednesday, January 5, 2011 6:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 6,582, Visits: 8,864
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
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1043018
Posted Wednesday, January 5, 2011 7:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
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!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1043028
Posted Wednesday, January 5, 2011 7:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
ForceExecutionResult is a great little debugging tool/task property. Great question.
Post #1043058
Posted Wednesday, January 5, 2011 7:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1043074
Posted Wednesday, January 5, 2011 9:01 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:26 PM
Points: 21,351, Visits: 15,031
Nice question - thanks



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1043127
Posted Wednesday, January 5, 2011 9:53 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1043173
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse