[!INCLUDE sqlserver-ssis] In this task, you enable logging for the data flow in the Lesson 3.dtsx package. Then, you configure a Text File log provider to log the PipelineExecutionPlan and ...

Use Script activity if you want to execute nonquery scripts and your data store is supported. Alternatively, consider to use stored procedure that returns a dummy result to execute your nonquery ...