Integrated services in MS SQL Server
Integrated services are used to implement ETL (Extraction, Transform and Load data) and administrator jobs.
Integrated services are used to implement ETL (Extraction, Transform and Load data) and administrator jobs. BIDS (Business Intelligence Studio until 2008 R2 version) and SSDT (SQL Server Data Tools from 2012 later) are the environments for this service.
SSIS Basic Architecture
Solution (a set of projects) → Project (a set of packages) → Package (a set of tasks for ETL and administrators).
Each package can include components:
- Control Flow (Containers and Tasks)
- Data Flow (Source, Transformation and Destination)
- Event Handler (send message, Email)
- Package Explorer (see all in 1 package)
- Parameter (user interaction)
Here are the steps to open BIDS / SSDT.
Step 1 - Open the BIDS or SSDT from the MS SQL Server program group. The screen below will appear.
Opened SSDT screen
Step 2 - Go to File in the left corner and select New > Project to open the screen below.
Select the new Project
Step 3 - Select Integration Service under Business Intelligence in the upper left corner of the screen above to get the screen below.
Integration Service opened
Step 4 - On the screen above, select the Integration Services Project service or the Interation Services Import Project Wizard according to your own requirements to create the package.
Previous article: Execution Plans - Execution plan in MS SQL Server
Next lesson: Analysis services in MS SQL Server
You should read it
- How to start and stop services in MS SQL Server
- Reporting service in MS SQL Server
- Analysis services in MS SQL Server
- SQL Server 2019 - Microsoft Relational Database Management System
- How to set up your own Git server on Linux
- The difference between web server and app server
- What is VPS? VPS used to do? What is VPS different from Server?
- Learn about the architecture of MS SQL Server
- Instructions for installing MS SQL Server
- New points in SQL Server 2017
- HOW TO INSTALL ISA SERVER ENTERPRISE 2000 - Part II
- Network basics: Part 3 - DNS Server