The Execute SQL activity allows you to execute one or many SQL statements and stored procedures in one step. The activity supports inserting, selecting, updating, and deleting records from a database. If you are familiar with writing SQL statements in SQL Server Management Studio, then you can use the same statements in the Execute SQL activity. The Create Database Records, Delete Database Records, Retrieve Database Records, Update Database Records activities are limited to only being able to work with one database table (or view for the Retrieve) at a time. Using the Execute SQL activity requires you be familiar with writing SQL statements and can improve your processes by allowing you to combine multiple database steps into a single activity. This section provides information on the following topics:
