Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saiabhiram
Starting Member
17 Posts |
 Posted - 2010-05-12 : 12:31:28
|
| Hello,I have an SSIS package. I have a parameter or variable and if the variable is set to 'Y' the SSIS package needs to run an execute Sql task. If 'N' it needs to go thru some data flow tasks. What is the best way to approach this problem. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-12 : 12:36:37
|
| you can use precedence constraint with constraint and expression option.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
saiabhiram
Starting Member
17 Posts |
Posted - 2010-05-12 : 12:43:22
|
| Thanks for your reply so much. But, sorry, I am quite a novice to SSIS. Can you be more elaborate for me. If you could do that, that would be great!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
saiabhiram
Starting Member
17 Posts |
Posted - 2010-05-12 : 17:15:34
|
| Thanks so much. It works now. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-13 : 10:10:42
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS Branching