SQL Server Compact Edition Connection Manager The task can use the connection types listed in the following table. The Execute SQL task can use different types of connection managers to connect to the data source where it runs the SQL statement or stored procedure. For example, using the Foreach Loop container, a package can enumerate files in a folder and run an Execute SQL task repeatedly to execute the SQL statement stored in each file. These containers implement repeating control flows in a package and they can run the Execute SQL task repeatedly. The Execute SQL task can be used in combination with the Foreach Loop and For Loop containers to run multiple SQL statements. Save the rowset returned from a query into a variable. If the SQL statement invokes a stored procedure that returns results from a temporary table, use the WITH RESULT SETS option to define metadata for the result set. Re-create fact and dimension tables before loading data into them. Truncate a table or view in preparation for inserting data.Ĭreate, alter, and drop database objects such as tables and views.
You can use the Execute SQL task for the following purposes: The task can contain either a single SQL statement or multiple SQL statements that run sequentially. The Execute SQL task runs SQL statements or stored procedures from a package. SSIS Integration Runtime in Azure Data Factory
0 kommentar(er)
