I have been working with SSIS for some time and basically learned most of the tricks the hard way. I'm looking forward to your future articles and would like to suggest some topics to include.
1. When working with loading data from file servers into SQL go into detail with some practical examples of parsing excel files with multiple worksheets from remote shares. This is a common practice as many small companies keep files all over the place and want them parsed for BI.
2. When working with data flows go into detail and show some good examples of properly setting up and utilizing iterations "running processes through a loop container" this was a difficult task for me to figure out and I'm sure others as well.
3. Package variables. Most examples of setting up package variables and vague. Please go into depth on some reasons why one would use package variables and how to properly set them up, and most importantly... how to troubleshoot them when the fail. This leads to my final wish list item.
4. Troubleshooting package errors. Examples of the most common errors, what they mean, and how to correct them is most warranted.
Thanks and keep up the great work.