First Step of Control Flow in SSIS Package
-
I have a SSIS package that I saved using the import wizard in SSMS. The import uses a table to hold all of the values imported from a flat file before exporting those values into a permanent table. For example, the flat file itself is imported into 'mytable'. The contents of 'mytable' are then transferred to 'mypermanenttable'. I recently added a drop mytable SQL statement to the end of the SSIS package. Since I am now missing 'mytable' when I run the SSIS package again, I added a T-SQL statement to before the 'Preparation SQL Task 1' step in Control Flow that would create 'mytable' before the import begins. I get an error when I try running the entire SSIS package. I can however run every step of the SSIS process one by one and complete the entire package without any problems this way. I am guessing there is some validation in the 'Preparation SQL Task 1' step that checks for 'mytable' before my create table 'Execute T-SQL Statement Task' runs. How would you fix this issue?
-
Try going to the properties of the step causing the validation error and setting delay validation to true.
-
There is no validation option in any of the steps
-
It's not an option you can change in the editor. You have to set it from the task properties.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply