31 Days of SSIS – The Introduction

by Jason S, posted in SQL Server 2008, SQL Server 2008 R2, SQLServerSyndication, SSIS

Update: You can now purchase this content as a Kindle book here – 31 Days of SSIS with SQL Server 2008 R2

Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A Day.  Since then there have been two other series that followed a similar concept – Paul Randal (Blog | @PaulRandal) with A SQL Server DBA Myth A Day and Jonathan Kehayias (Blog | @SQLSarg) with An XEvent A Day: 31 days of Extended Events.

Since I’ve been working on an SQL Server Integration Services (SSIS) project over the last six months, I thought I would blog a little about some of the tips and tricks and solutions that I’ve worked through with this project and other SSIS projects I’ve worked on.  This isn’t intended as training for learning how to use SSIS.  The intent is to help prevent some of the same difficulties that I’ve run into and to provide some ideas on how to use SSIS creatively.

I’ve figured I’d follow suit with a series on SQL Server Integration Services (SSIS).  Unlike many DBAs, I’ve spent quite a bit of time using SSIS.  Enough time that I figure I probably have 31 days worth of posts that I can write based on some of my experiences.

The 31 Days of SSIS

Below are all of the posts in this series and it’ll be updated each day as the new posts come out.  If you want them all in a single source you can buy it from Amazon for your Kindle as 31 Days of SSIS with SQL Server 2008 R2.  Alternatively, you can get it for free as a PDF as well – 31 Days of SSIS.

  1. 31 Days of SSIS – Raw Files Are Awesome (1/31)
  2. 31 Days of SSIS – Using Breakpoints (2/31)
  3. 31 Days of SSIS – Data Flow Breakpoints?! (3/31)
  4. 31 Days of SSIS – Folder Structures (4/31)
  5. 31 Days of SSIS – One Variable to Rule Them All (5/31)
  6. 31 Days of SSIS – Recursive SSIS Package (6/31)
  7. 31 Days of SSIS – What The Sorts?! (7/31)
  8. 31 Days of SSIS – Merge Join Is My Friend (8/31)
  9. 31 Days of SSIS – Override Variables (9/31)
  10. 31 Days of SSIS – Pivot Transformation (10/31)
  11. 31 Days of SSIS – UnPivot Transformation (11/31)
  12. 31 Days of SSIS – UnPivot Alternative (12/31)
  13. 31 Days of SSIS – Create XML Document (13/31)
  14. 31 Days of SSIS – Instant Excel Spreadsheet (14/31)
  15. 31 Days of SSIS – Every Which Way Outputs (15/31)
  16. 31 Days of SSIS – 10 Things About Expressions (16/31)
  17. 31 Days of SSIS – Environmental Variable(17/31)
  18. 31 Days of SSIS – SQL Server Configuration (18/31)
  19. 31 Days of SSIS – DTSConfig Configuration (19/31)
  20. 31 Days of SSIS – No More Procedures (20/31)
  21. 31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
  22. 31 Days of SSIS – Data Flow Expressions (22/31)
  23. 31 Days of SSIS – Generating Row Numbers (23/31)
  24. 31 Days of SSIS – One Package, Unlimited Databases (24/31)
  25. 31 Days of SSIS – One Package, Unlimited Tables (25/31)
  26. 31 Days of SSIS – Small Package, Big Win (26/31)
  27. 31 Days of SSIS – Adding Some Delta Force (27/31)
  28. 31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)
  29. 31 Days of SSIS – Exporting Execution Plans (29/31)
  30. 31 Days of SSIS – Importing Execution Plans (30/31)
  31. 31 Days of SSIS – SSIS Naming Conventions (31/31)

116 thoughts on “31 Days of SSIS – The Introduction”

  1. Pingback: 31 Days of SQL Server Management Studio | Russ Thomas - SQL Judo
  2. Pingback: 31 Days Of DataStage – Introduction | dwbi tutorials
  3. Pingback: SQL Server Integration Services Resources | Question Driven
  4. Pingback: 31 Days of SSIS for SQL Server 2014 Update Question | Strate SQL

  5. Hello, I brought the Kindle version of your blog. Where is the link to download the resources? Is there a complete file zip?

    Like

  6. Pingback: Wrapping Up 2013 - SQL Server - SQL Server - Toad World
  7. Pingback: 31 days of SSIS « Joel On The Go

    1. Hi Sridhar – if I get a chance, I’ll put together a post on error handling. I’m currently in the process of putting together an extended events book.

      Like

  9. Pingback: Top 10 SQL Server Resource Websites | Fun Analytics

  10. Cannot tell you how much I enjoyed reading this (only reached to third day)!! I am starting with SSIS just now. And it amazes me how you have cared enough to neatly document your learnings. This site is really wonderful, the witty narrative and the clarity and ease of its teaching 🙂 Its on my favourites and has been passed to some friends.

    Like

  13. where is the link to download all the packages as we have in the 31 Days of SSIS – Recursive SSIS Package (6/31) to download the package at the bottom .
    will appreciate if you share the link …

    Like

    1. Thanks, glad they’ve been helpful. I wasn’t sure when I wrote these if anyone would care about them. I’ve been a bit wrong on that and people have… a lot.

      Like

  15. Pingback: Addicted to Blog « Mike Donnelly, SQLMD

  16. Hi Jason,

    I am in kind of situation here… Need to do Excel formatting. So I used script task to accomplish the task. But sadly on Prod server Microsoft office is not installed. Hence I cant use the references. Is there any work around? Any help is more than welcome.

    Like

  17. Pingback: Wearing All The Hats, T-SQL Tuesday #28 « Mike Donnelly, SQLMD
  18. Pingback: 31 Days of SSIS in a PDF | Strate SQL
  19. Pingback: Wrapping Up 2011 | Strate SQL
  21. Pingback: MSBI #3– SSIS #1- What is SSIS (SQL Server Integration Services) - Vishal Pawar's Blog
  22. Pingback: BI #3– SSIS # 1- What is SSIS (SQL Server Integration Services) - Vishal Pawar's Blog
  23. Pingback: BI #3– SSIS # 1- What is SSIS (SQL Server Integration Services) « (B)usiness (I)ntelligence Mentalist

  25. Fabulous series and kudos for doing it. But I guess in the end I remain unchanged in my view the entire SSIS dev team to shut down development for six months and spend that time working in the trenches on real customer projects doing enterprise-level integration with SSIS on a daily basis. After that come back together to plan and develop a new version of the product that is not so idiosyncratic, frustrating, and just plain peculiar to use.

    Like

  26. Pingback: Studying for 70-448, Week 2 | SQL Servings
  27. Pingback: Writing A Month Long Blog Series | Strate SQL
  28. Pingback: 31 Days of SSIS – SSIS Naming Conventions (31/31) | Strate SQL
  29. Pingback: 31 Days of SSIS – Importing Execution Plans (30/31) | Strate SQL
  30. Pingback: 31 Days of SSIS – Exporting Execution Plans (29/31) | Strate SQL
  31. Pingback: Jim Croce and the Foreach (File) Loop Container | Mark V SQL
  32. Pingback: 31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31) | Strate SQL
  33. Pingback: 31 Days of SSIS – Adding Some Delta Force (27/31) | Strate SQL
  34. Pingback: 31 Days of SSIS – Small Package, Big Win (26/31) | Strate SQL
  35. Pingback: Presenting on #SSIS to EDMPASS Today | Strate SQL
  36. Pingback: 31 Days of SSIS – One Package, Unlimited Tables (25/31) | Strate SQL
  37. Pingback: 31 Days of SSIS – One Package, Unlimited Databases (24/31) | Strate SQL
  38. Pingback: 31 Days of SSIS – Generating Row Numbers (23/31) | Strate SQL

  39. I am very exited.. I am aware of few basics.. I will start going through each and every post of 31 days SSIS..

    Thanks,
    Prawin

    Like

  40. Pingback: 31 Days of SSIS – Override Variables (9/31) | Strate SQL
  41. Pingback: 31 Days of SSIS – Merge Join Is My Friend (8/31) | Strate SQL
  42. Pingback: 31 Days of SSIS – What The Sorts?! (7/31) | Strate SQL
  43. Pingback: 31 Days of SSIS – Recursive SSIS Package (6/31) | Strate SQL
  44. Pingback: 31 Days of SSIS – One Variable to Rule Them All (5/31) | Strate SQL
  45. Pingback: 31 Days of SSIS – Folder Structures (4/31) | Strate SQL
  46. Pingback: 31 Days of SSIS – Data Flow Breakpoints?! (3/31) | Strate SQL

  47. Do you have a starting file and/or example data files that is going to go with the 31 day series. I know on day 1 you skipped a few steps and did not talk about what components are needed. Also, it looks like day 2 takes of from day 1. I look forward to following along the month long series.

    Like

    1. If the posts have a specific package, I'll be including that package as a zipped file at the end of the post. For other posts that don't necessarily rely on a specific package, I'll be using the package from the previous day since the package itself doesn't matter. This way, the included packages can be added to any project. Also, the posts will always use AdventureWorks for their source data.

      Like

  48. Pingback: 31 Days of SSIS – Using Breakpoints (2/31) | Strate SQL
  49. Pingback: Tweets that mention 31 Days of SSIS – The Introduction | Strate SQL -- Topsy.com
  50. Pingback: 31 Days of SSIS – Raw Files Are Awesome (1/31) | Strate SQL

Comments are closed.