Ssis-927 -

| Source | Destination | Technique | |--------|-------------|-----------| | | SQL Table, Azure Data Lake | Use JSON Source (SSIS 2022) or XML Source → Data Conversion → OLE DB Destination . | | Parquet | Azure Synapse, Azure Data Lake | Use Azure Feature Pack → Parquet Source . | | REST API (JSON) | Staging Table | Web Service Task → Script Component to parse JSON into columns; optionally use JSON Source from the SSIS Feature Pack . |

| Item | Version | Installation Steps | |------|---------|--------------------| | | 2019‑2024 (Express, Standard, or Enterprise) | Use the SQL Server Installation Center → Database Engine Services . Enable Integration Services feature. | | SQL Server Data Tools (SSDT) | Visual Studio 2022 (Community/Professional/Enterprise) | In VS Installer → Individual components → “SQL Server Integration Services” and “SQL Server Data Tools”. | | .NET SDK | .NET 8 (for script tasks) | dotnet sdk install 8.0 (Windows: use the MSI). | | PowerShell | 7.x (cross‑platform) | winget install Microsoft.PowerShell | | Azure CLI & AzCopy | Latest | az login ; azcopy for large file moves. | | Optional – Azure Data Factory (ADF) Integration Runtime | – | az synapse workspace create → Managed Integration Runtime for hybrid pipelines. | SSIS-927