O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. From the SSIS toolbox, drag and drop, and Execute SQL Task on the control flow, and rename it sql_truncate_Staging_StgCloudSales.
  2. Double-click on it to open the SQL Task Editor. Set the properties as follows and click on OK:
    • Connection: cmgr_DW
    • SQL Statement: TRUNCATE TABLE [Staging].[StgCloudSales];
  1. From the SSIS toolbox, drag a Foreach Loop Container and rename it felc_StgCloudSales.
  1. Double-click on it to open the Foreach Loop Editor, and assign the properties in the Collection pane, as shown in the following screenshot:
  1. Now go to the Variable Mappings pane and add a string variable called User::AzureAggregatedData ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required