April 25, 2012 at 8:00 am
Is it possible to run a single task in a package after it has been deployed
April 25, 2012 at 11:15 am
You could do it if you designed the package to have 2 paths where 1 just executes that single task based on a configuration that sets a value in variable which you could then use in precedence constraints.
Another option is to place that task in its own package so you can execute it as a child task in the existing package or as a stand alone package.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 27, 2012 at 6:00 am
Jack Corbett (4/25/2012)
Another option is to place that task in its own package so you can execute it as a child task in the existing package or as a stand alone package.
+1 for child package
You cannot run an individual task like you can in BIDS by right-clicking it and select Execute Task/Container.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply