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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy