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.
Presented by Peter Doyle at SQLBits IV
  • Downloads
    Slide deck available Slide Deck 34 KB
    Video available WMV Video 142 MB
  • SpeakerBIO
    I have been an independent contractor for 20 years and before that I worked for a software house for 5 years in the late 80's. I started out as a Lotus 1-2-3 developer and then did database development with Paradox. That soon became Access development which progressed to Access with SQL Server in a client server environment. Now I tend to work as a SQL Server developer specialising in optimisation.
  • Video