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

Can we enable or disable particualar "Execute SQL Task" ? Expand / Collapse
Author
Message
Posted Thursday, April 24, 2014 8:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:36 PM
Points: 92, Visits: 58
Hi All

I have created a package to track the log of SysSsisLog table into another table. I have used the stored procedure to maintain the log. What I want is to enable or disable this sql task from another task by passing parameter 0- LOG, 1- NO LOG. Can it be possible?

Please let me know if there is any work around. Thanks in advance :)

Regards,
Nikhil
Post #1564667
Posted Thursday, April 24, 2014 8:20 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 10:09 AM
Points: 141, Visits: 313
You can use precedence constraints in SSIS and have an expression over it to do this.

Good Luck :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1564668
Posted Thursday, April 24, 2014 11:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:36 PM
Points: 92, Visits: 58
Thank you :)

Can it be possible for particular task./package?
Post #1564804
Posted Thursday, April 24, 2014 12:21 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 504, Visits: 1,870
Nikku (4/24/2014)
Thank you :)

Can it be possible for particular task./package?


Yes. You might want to review this article by Andy Leonard from the Stairways series on SSIS. It discusses how to set up variables and use expressions in precedence constraints.

Advanced SSIS Workflow Management – Level 8 of the Stairway to Integration Services


Edit: Correct a misspelling
Post #1564817
Posted Friday, April 25, 2014 12:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 11:36 PM
Points: 92, Visits: 58
Thank you Sir :) it helps me a lot.
Post #1564972
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse