Setup Install SQL Server Data Tools (SSDT) via Visual Studio installer and include 'Integration Services'. Key Concepts Control Flow: The orchestrator loop (e.g., Execute SQL Task, For Loop Container). Data Flow: The actual data pipeline mapping source to destination (e.g., OLE DB Source -> Data Conversion -> OLE DB Destination). Deployment SSIS Projects map out to .ispac files, which are then deployed to the SSISDB Catalog on SQL Server.