31 Days of SSIS

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.

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)