Learn MS SQL Integration with Free Lessons & Tips

SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

1. Download the starter data set.
2. Use the Database Inspector.
3. Read data with a SELECT statement.
4. SQL SELECT statement.
5. Read email data using a SELECT statement.
6. Use SELECT statements with aggregate functions and distinct values.
7. Reduce columns with aggregate functions.

The Integration Services service is installed when you install the Integration Services component of SQL Server. By default, the Integration Services service is started and the startup type of the service is set to automatic. The service must be running to monitor the packages that are stored in the SSIS Package Store.

Mailchimp SQL database integrationYou can connect your Mailchimp database to different SQL databases and data warehouses like MySQL, MSSQL, BigQuery, OracleDB, etc. For Mailchimp to link to your database, you'll need to access the required data using the REST API that Mailchimp provides

The SSIS Import/Export Wizard lets the user create packages that move data from a single data source to a destination with no transformations. The Wizard can quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.