SSIS by example

SSIS development can be a frustrating experience.  However it is becoming an increasingly important part of the SQL Server tool set and an important skill for the professional SQL server developer. The best way to learn SSIS is to see a real world example being built from scratch.  The brief is to import a collection of delimited files into sql server, date stamp and archive the files, capture any errors and get the data into a SQL server table.  It sounds straight forward but what if the file contains embedded quotes for example ("ABC","DEF",""Hello world, again"").  Try importing this line using SSIS!  You have to be able to adapt when using SSIS and this session will give you some ideas for getting round SSIS limitations and getting the job done.

Peter Doyle

I have been an independent contractor for 15 years and before that I worked for Software House for 5 years, before that I was an accountant (for my sins).  For the last 10 years I have worked with SQL Server as both a DBA and Developer.  I now tend to pigeon-hole myself as a SQL Server developer.  The area I get most satisfaction working in is optimisation and tuning.  Recently I have been building a datawarehouse for a client using SSIS extensively hence the submission

---

Downloads

File Type Ext ContentName Presentation .ppt Slide Deck

<< 1 >>

---

Other sessions from this conference

AddIns for SSMS - build your own

Comparing Azure storage and SQL Data Services

Data Mining and SSIS - makes sense.

Data Warehouse Data Modelling

Data Warehousing features in SQL 2008

Database Maintenance Optimization

Designing Effective Aggregations in Analysis Services 2008

Effective test-driven database development

End to End Report Creation and Management in SQL Server Reporting Services 2008

High Availability in SQL Server 2008

Implementing Clustering using SQL Server

Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Making the SQL developer one of the family with Visual Studio Team System

Message in a bottle: Service Broker from 1 to 100 in 75 minutes!

NHibernate – Open Source Object Relational Mapping (ORM)

Performance Optimization with SQL Server 2008

Performance Tuning your TSQL

Securing and Hardening a SQL Server Implementation - Notes from the Field

SQL Server Architecture: The life of a query

SQL Server’s storage engine

SSIS Nuggets Live

Stop throwing hardware at the problem !

Understanding ADO.NET Data Services

Understanding Graphical Execution Plans

Universal calculated measures in MDX queries

Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

What’s New in SQL Server 2008 T-SQL