Popular posts on this site from Google! Analytics

SSIS-related posts getting the most traffic by far.

I was looking at Google Analytics the other day on my blog and wanted to know what topics and pages generate the most traffic;  I sort of had a good idea but wanted to verify by checking over the past year or so. Here’s the list of the top five pages on this site (not including off-topic and default.aspx page) for distinct hits.  Kind of interesting I guess.

1. Use variables in the SSIS data flow tab
    
   
2. Reason Token Based Server Access Violation Failed Error
   
   
3. sp_executesql string size in SQL Server 2005, 2008 
   
   
4. Create a custom assembly in SSIS 
   
   
5. SSIS Pivot, a simple and easy explanation
   

It turns out that three of the top five posts (60% for those who are math-challenged) that gain the most page views are SSIS-related posts.  I think it’s cool to know that so many people are using SSIS and are looking for assistance and examples to help them in their shops.  When I need some help, a blog post with a generic and straightforward example with screen shots is imperative, and I have tried to make my examples easy to read without a lot of clutter as well.  I'm looking forward to doing more SSIS posts in the future alongside some of our great SSIS practitioners and experts, such as SQL Sever MVP Jamie Thomson and SQL Server MVP Tim Mitchell;  it's guys like these who give us all great ideas and motivation to go explore SSIS further.

I hope that I have helped someone out along the way and, as always, I appreciate your visiting my blog and for the great feedback that you send.  This blog is my scratchpad for jotting stuff down, but truth be told I do this for you guys, not myself.

Thank you,

Lee

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