eugenesavenko/mssql_ssis

A look at ETL features with SSIS

MSSQL_SSIS

Developed with Visual Studio Community 2015

---

---

###Techs

Tech
MS SQL SERVER -> SSIS
C#

---

###Features

Feature
Creating control tasks
Creating data tasks
Utilizing SQL Server, Text, Xml and Excel sources & destinations
Running SQL Commands
Using Data Views
Sorting Transformations
Aggregate Transformations
Sampling Data
Combining data using UNION ALL
Data Conversion
Conditional Split
Debugging
Lookup Transformations
Caching
Sequence Containers
For Loop Containers
For Each Containers
File System Tasks
Expression Tasks
Unions
Constraints
Event Handling
Logging

---

Packages

Package	Description	Features
ExportEmployeesToExcel.dtsx	Exports Employee Table From Sql Server To Excel	OLE DB Source, Excel Destination
ImportInstallersToSqlServer.dtsx	Runs a sql command to truncate installer table prior to importing data from flat file	SQL Task, Flat File Source, OLE DB Destination
LondonBerlinCustomers.dtsx	Uses a conditional split to export customers from london & berlin to different worksheets in an excel file	OLE DB Source, Conditional Split, Multiple Excel Destinations
AggregateCustomers.dtsx	Counts the number of customer per city and outputs result to an excel worksheet	OLE DB Source, Aggregate Task, Excel Destination
SortCustomers.dtsx	Sorts customers by city prior to exporting them to an excel worksheet	OLE DB Source, Excel Destination, Sort Task
ImportExcelInstallersToSqlServer.dtsx	Demonstrates converting unicode string to non unicode strings	OLE DB Source, Excel Destination, Data Conversion
ExpressionBuilder.dtsx	Builds a message that depends on a number of variables	Script Task, Expression Task
Debugging	Demonstrates solving runtime errors, debugging data flow flows, control flows, setting breakoints, watching variables, script tasks & row count tasks	Excel Source, Row Count
LookupTransforms	Demonstrates how to lookup related table info when importing from an excel sheet	Lookup, Cache Transform, Union All, Data Conversion, Derived Columns, Excel Source, OLE DB Destination
ForLoopContainers	A quick look at For Loop Containers for iterating variables	For Loop Container
FileSystemIteration	A look a 'ForEach Containers' for iterating a file system, moving files and recording their file names in a db	File System Task, ForEach File Enumerator, Script Task, Precendence Constraints, Expression Tasks, Row Count Tasks
FreightTotals	Another look at ForEach Containers, this time to iterate database tables rows	ADO Enumerators
SchemaIteration	Another look at ForEach Containers, this time to iterate database schemas and writing to file	ADO.NET Schema RowSet Enumerators, Script Tasks
XmlIteration	Another look at ForEach Containers, this time to iterate over an xml file and output to a text file	NodeList Enumerator
Script Tasks	Uses a Script task to display MessageBox, and the result from this determines which route to process	Script Tasks, Sequence Containers, Conditional Splits
EventHandlers	Demonstrates Event Handling & Logging