Introduction to SSIS Or you want to take

Introduction to SSIS Or you want to take some data, change it, and put it somewhere else? Then boy do I have THE tool for you!

Who am I? Ed Watson Data Services Consultant or Ambassador of Mayhem Twitter: Blog: Linked. In: @SQLGator. com Linked. In. com/in/Watson. Ed

What exactly is SSIS? (insert Marketing speak) • Integration Services is a platform for building high performance data integration and workflow solutions, including extraction, transformation, and load (ETL) operations for data warehousing. • It is a framework to build packages to move and transform data using a GUI interface. • A component of Microsoft SQL Server Business Intelligence suite, includes SSAS, SSIS, and SSRS.

More Readable? Or Just My OCD?

SSIS, Holding All Your Data Together!

SSIS within the Business Intelligence Realm SSIS & SQL Server SSAS SSRS Power BI SSRS Portal Share. Point Excel with Power. Pivot Power. View

Extraction, Transformation, Load Sources Targets DB EDW DB DB ETL Marts DB Flat Files XML Excel

Where is ETL in the DW Process?

What if I am not doing a Data Warehouse? • Merging data from various sources • Cleansing and/or standardizing data • Automating administrative functions • Error handling and logging functionality • GUI (oh so gooey interface…like an ATM Machine)

SSIS Architecture…Who Cares Right?

Can I download these tools? BINGle SSDT-BI YES!!! Free!!

Solutions, Projects, and Packages…OH MYYY! Solutions Projects Packages

Control Flow vs Data Flow Oooops!

While We Are Talking About the Oooops ! Oooops! O ps o o o

Control Flow vs Data Flow

SSIS Containers

Variables

Variables (Expression Builder)

Package Configuration

Package Deployment Options 1. The File System 2. Package Store 3. SQL Server

2012+ Project Deployment Model

How to Execute a Package • In SSDT/BIDS, using the debug capabilities • Using DTEXEC, and DTEXECUI utilities • Using SQL Server Agent job (SSIS package execution is fully integrated with SQL Agent)

Resources • Innovative Architects (for your next integration project http: //Innovative. Architects. com) • Install SQL Server Integration Services (http: //bit. ly/1 DAPGV 3) • Data. Chix Blog (http: //datachix. com) • BI Developer Network (http: //www. bidn. com/)

Thank You!!!! Ed Watson Data Services Consultant or Ambassador of Mayhem Twitter: Blog: Linked. In: @SQLGator. com Linked. In. com/in/Watson. Ed