October 14, 2010 at 1:13 am
Hi
I have one requirement.In data flow task if i have 6 transformations,in that if i want disable 3rd transformation run the rest of package.was it possible to that?if yes could you please explain me with example
Thank you very much
sank
October 14, 2010 at 5:48 am
You cannot disable transformations in the data flow.
You can however disable tasks in the control flow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2010 at 7:39 am
You could add a condition split ahead of the transform to force the data around it, the merge the data back into the flow after the transform.
Why do you need to disable it? Why not delete it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2010 at 9:53 am
If the requirement is to bypass a specific transformation at runtime, I do not believe there is a native way to do that? If you know during design that there are certain transformations that might need to be skipped at runtime, perhaps you could put conditions in front of those transformations that depend on a variable value. You could then pass in a variable at runtime that will trigger the condition to either execute or bypass the transformation.
October 15, 2010 at 7:12 pm
Hey thanks for u r reply
Actually this not my project or any thing, last week i been in IBM for the seminar. After seminar one guy ask me.
That's why posted the topic
Sank
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply