Explore a collection of sample SQL Server Integration Services (SSIS) packages designed to demonstrate various features and common scenarios. These samples are provided to help you understand how to build robust and efficient data integration solutions.
This sample demonstrates a common ETL process: extracting data from a source, performing transformations (e.g., data cleansing, data type conversion), and loading it into a destination database. Includes examples of using Derived Columns, Conditional Splits, and Data Flow Tasks.
Download Sample (ZIP)Learn how to consume data from a web service using SSIS. This sample showcases the use of the HTTP Connection Manager and Script Components to retrieve data from a public API and process it.
Download Sample (ZIP)Implementing effective error handling and logging is crucial for production SSIS deployments. This sample provides patterns for redirecting error rows and capturing execution logs using the built-in logging capabilities.
Download Sample (ZIP)This package illustrates how to perform various file system operations, such as creating, deleting, and moving files, as well as managing directories. It utilizes the File System Task for these operations.
Download Sample (ZIP).sln file in Visual Studio with SQL Server Data Tools (SSDT) installed.These samples are a starting point. Feel free to adapt and extend them to meet your specific business requirements.