asked
SSIS Questions
Hi I wonder if anyone can advise me on the following: 1. Is it possible to run a selection of steps in an SSIS package without disabling all those you don't want? 2. Can you use a variable as a dynamic connection string where the connection is to a .dbf file. This has worked fine for flat files but not where it's looking for the data in the .dbf files. If this is possible, then I'll post what I've done and maybe this can be looked at as a separate issue. Many thanks
Hi, The property "Disable" of the tasks in the package can be configured in a db or somewhere . so every time when you run the package it will run only the enabled task(picked from the config).This way we can also execute specific tasks in the packages which are deployed. For Question 2 ,We can have the .dbf file path in a variable and map this to the connection string property in the expressions of the connection. Thanks, Kannan
+1 to @Kannan.. I add only to point 1. You can dynamically disable the steps you do not want to execute based on expressions using configured variables as @Kannan stated. As alternative you can design the execution constraints appropriately with expressions to execute or bypass particular steps.
