My top blog posts for 2011…SSIS still leading the way

Every so often I take a look at statistics on my blog, and occasionally post what I’m seeing.  SQL Server Integration Services (SSIS) is still blowing away just about every other topic, probably even more so than last year. I’m not working very much with SSIS at the present time, but still like doing some cool stuff with the tool if the opportunity presents itself.  While I haven’t done full-time SSIS in almost a year, I did make two really great packages this past few months, one a “file generator” somewhere on this site, and more work on “dynamic” SSIS packages.  I think SSIS still has a long way to go as a leading ETL tool, but no doubt that the interest it has arisen in the SQL community is to be noted.

Here are my blogs with the highest page views for the first half of the year:

1. Default.aspx
2. SSIS Pivot Task example – a simple, easy explanation
3. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors
4. Demystifying the SSIS Script Component, Part 2
5. Demystifying the SSIS Script Component, Part 3
6. SSIS and Linq
7. Relative paths in SSIS to make things simpler
8. Could not load file or assembly 'VSTADTEProvider.Interop
9. MongoDB vs. SQL Server - INSERT comparison
10. Table Partitioning and LOCK_ESCALATION in SQL Server 2008

Looks like SSIS has 6 of the top 10…actually around the end of last year it was seven I think.

This weekend I’m rolling out the series on “dynamic” SSIS packages. It’s extremely cool, programming the SSIS Application Programming Interface (API); I think you’ll like it a lot.

Thanks for reading,
Lee

-----------------------