as well as to prepare and truncate data and to return result sets. You can also combine tasks with iterative code containers to perform repeated actions. Use the Execute SQL Task Editor in SSIS ...

Microsoft SQL Server Integration Services, or SSIS ... data flow task. Double-click the task to switch to the data flow view. Click the "New Variable" button and choose "Object" for the data type.