SSIS_Tutorials from Pragmatic Works Cours - Introduction to SSIS

Get the dataset

1. You can download AdvendtureWorks databases backup files from https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
2. SSIS - I tried installing SSDT 2017 on Win 2019 server, however, that did not work - installation failed. Finally I downloaded SSDT 2015 and that worked. https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-ver16 can be used to download prior releases of SSDT which you will find under section - "Privous SSDT releases"
3. Or Try download Vistual Studio (2017 or anything else) Community Edition
4. Download resources

Module 00 - Getting Started

Just intro

Module 01 - SSIS Overview

Explanation of ETL and Cube etc

Module 02A - Introduction to the Development Environment and the Control Flow

A. Solution File
1. SSIS Project
- SSIS Package1 (dtsx)
- SSIS Package2
- SSIS Package3
2. SSAS Project
-- SSAS Tabular Cube
3. SSRS Project
-- SSAS Reports
4. SSIS Project 2

• However, keep 1 sol - 1 proj - 1 tech
• To get the control windows -- Go to View Menu
• Go to Tools --? Options --> Project & Solutions --> Always show solutions (There are many things here)
  A. Options
  
  1. Control Flow
  2. Data FLow
  3. Parameters
  4. Event Handlers
  5. Package Explorer

Module 02B - Introduction to the Development Environment and the Control Flow

1. Reusable - Create connection manager at project level instead of package level
   1. Right Click on Connection Manager Box - by default its a package level
   2. If you right click on "Connection Manager" from Solution Explorer - that way you create it at project level. This has ext as .conmgr and in bracket it says (project)
   3. or, you can change project conn to package conn or vice versa, by right clicking on connection itself at "Connection Manager Box"
2. Naming Conventions - ProviderType_DatabaseType_databaseName e.g. OLEDB_SQL_PWInsurance

Module 02C - Introduction to the Development Environment and the Control Flow

1. Control flow is like Worklet or Mapplet
2. Tasks - inside control flow
3. Precedence Constraint - Sucess, Failure, Completion (And/Or)

• Right click on link and select Success \ Failure \ Completion based on need
• To get tool tip for sucecss -- Tool =--> Options --> Business Intelligence Designer ---> Integration Services Designer --> Show precedence constraint labels
• Double click on link --> Constraint Editor Window --> Select Value out of above 3 or choose Evaluation Operation as Expression/Constrain/(and/or)
• Double click on link --> Constraint Editor Window --> At bottom on of Window - select Logical OR or AND

5. Containers

To execute -- F5, Start or Right click on Package select Execute Package
To Stop - Shift + F5, Stop or Click on URL

SSIS Toolbox (right hand corner icon)

Logical OR