# SSIS

## Getting Started with SSIS

We'll begin with the basics and then build up from there!

### Import/Export Wizard

A simple outline of using the import and export wizard to copy data from a SQL table, exporting it to a destination file (text file or excel file)

![](https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnFpA8Pg-PIpQphXtm%2FImport_Export%20Wizard.jpg?alt=media\&token=e09d5c50-4024-4a92-9551-d44f6847b266)

{% file src="<https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGcRx0gCxmXUSWsxZ%2FImport_Export%20Wizard.pdf?alt=media&token=3b5ede6f-cb42-462a-8590-6cbe4556f796>" %}
Import/Export Wizard
{% endfile %}

### Build Package with SQL Server Data Tools

SQL Server Data Tools has various Integrations Services Tools that enable you to create sophisticated ETL Solutions. In this example we’ll be export data from SQL to a “.Txt File”

![](https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnG11EvzD1OwIVk2Di%2FBuild%20Package%20with%20SSDT.jpg?alt=media\&token=2b2ccdb6-80ac-491f-af2d-eee3112bfd1a)

{% file src="<https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGijp93dek4gpdJhU%2FBuild%20Package%20with%20SSDT.pdf?alt=media&token=11d5fdb3-feeb-4870-b974-ca0ac24122ed>" %}
Build Package with SSDT
{% endfile %}

### Run Package with Package Utility

The Execute Package Utility provides an easy to use user interface for executing packages, as well as for changing settings prior to running a package.

![](https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGD-5CYr39lUOgMRG%2FRun%20Package%20with%20Package%20Utility.jpg?alt=media\&token=f035c039-306a-488a-bb8c-2187138ecb50)

{% file src="<https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGnMBKyLJ70rlA2tV%2FRun%20Package%20with%20Package%20Utility.pdf?alt=media&token=21f484f0-480a-4e71-b2d2-135b09ca05cc>" %}
Run Package with Package Utility
{% endfile %}

### Create DataFlow Source

Data Flow sources provide connectivity to various data sources i.e. databases or Flat Files. A Data Flow object in SSIS reads data from a source and outputs data in columns to the Data Flow Pipeline.

![](https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGOGDJHzmxxOGorqh%2FCreate%20DataFlow%20Source.jpg?alt=media\&token=5467d43a-d2fb-4cfc-9a92-51d177e451f3)

{% file src="<https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGuPSKDM7M_AJzz38%2FCreate%20DataFlow%20Source.pdf?alt=media&token=1a0e2376-4c9e-4f31-ad48-0d72f17f5f36>" %}
Create DataFlow Source
{% endfile %}

### Create DataFlow Destination

Data Flow Destination provide a way for various data sources i.e. databases or Flat Files to connect to the Data Flow Pipeline. A Data Flow Destination object reads data from the Pipeline and the passes the data to the destination.

![](https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGYXMN9pz207dJZd_%2FCreate%20DataFlow%20Destination.jpg?alt=media\&token=19069cc0-4573-4168-ad64-366dc77d093d)

{% file src="<https://920316408-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lb2DlPHrRwBU3C_PNok%2F-LbnFYd4ygkjc_Euv1nE%2F-LbnGyjJM5V2vBix8_G6%2FCreate%20DataFlow%20Destination.pdf?alt=media&token=4b8e7e45-e587-4fa0-9d9e-13329bc4150f>" %}
Create DataFlow Destination
{% endfile %}