Archive for January, 2011


Troubleshooting SSIS Webinar

I attended my first Business Intelligence webinar hosted by Pragmatic Solutions.  They plan to host webinar sessions every Tuesday and Thursday between 11 am and 12 pm EST for all of 2011 and I do plan to attend many of them as I continue to increase my knowledge in Business Intelligence and SQL Server technology.

In this first session, Mike Davis discussed how to troubleshoot SSIS packages as you work through them.  I thought it was a very good session and took a couple of nuggets from the session which I attended.  These include…

  • When changing expressions involving database names and file names, check connection expressions and SSIS configuration packages which may overwrite changes to such items as part of troubleshooting
  • When changing a step in the data flow at the top of the process, check all steps below which feed it to make sure of the impact on those subsequent steps
  • You can collapse execution results to focus on errors in the Execution Results tab
  • When using variables from a script, ensure to include them in the Read Only Variables/Read Write Variables section.
  • Breakpoints can be used during debugging to help troubleshoot issues.  Make sure all breakpoints are deleted before releasing the package to production.
  • Handle all error handling in the Event Handler tab and not as a script task (particularly multiple links)
  • SQL commands are recommended for loading from tables versus grabbing entire tables to ensure against pulling unwanted data and it not as vunerable to table structure changes as it would be for a full table load.

Like I mentioned I gleamed a lot of nice information about SSIS usage and plan to attend many of these sessions in the future where I will comment on them through this blog.  Please comments as I am big fan of information sharing where technology is concerned.

Ran My First Half Marathon

On January 8th of this year, I ran my very first half marathon.  For those of you who do not know, a half marathon is a 13.1 mile race.  This race took place at Disney World in Orlando, Florida.  It began rather early in the morning, at approximately 5:30 am which was great for me because I do my best running first thing in the morning.  I ran the race with my fraternity brother from Tallahassee – Dr. Juan Guardia. 

This is a race I have trained for, for the last 2 and a half years.  I started by trying to run 3 miles at a time.  When I first began I could barely get myself past a mile but in a couple of weeks after dilligently trying I managed to complete one half of the leg, walk a quarter of a mile , and then run the rest.  With enough repeated attempts I was able to run the full three miles without stopping.  Not too long I started running 5K races with some of my fraternity brothers at Disney World as well as a few in Jacksonville.  As my running ability improved, I had many thoughts about running longer  races.

What got me started on my way was when I began working for Lender Processing Systems.  In the IT department where I work, I work with a few gentlemen who are very good runners.  As I began running during my lunch hour, they would join me and as they got their running legs back, they would push me beyond my limits allowing me to venture into running 5 and 6 mile lengths rather than the 3 mile ones I was used to, so eventually I began wondering if I could run a half marathon. 

As I kept tellimg myself that one day that I would do it, an opportunity presented itself when Juan made the commitment to run the race in Disney.  After much deliberation I decided to do it and just made the deadline at Disney for registration.

Juan and I ran the race and we did great for 10 miles, running neck in neck, and then I hit my wall where my “dogs” weren’t barking, they were howling !!!  But I was determined to finish the race so althought it required a little bit of walking and a whole lot of hobble-jogging, I finished the race in 2 hours, 16 minutes, 47 seconds. 

I am very encouraged by the results and I am proud, but as I look forward, I am looking forward to the next half marathon, although for now, I am training for the Gate River Run.

Welcome to My New Site !!

Welcome to WordPress.com. This is my first post. I welcome you to my new blog site using word press which I have used to support my church’s website – www.jaxcoc.org for many years now.  I am excited to have this new site and plan to use it to mainly post technical articles and discuss training and projects I am working on to further my technical expertise.  I will also however use the site to post articles about items of interest for me including my love or running and exercise among others.  I encourage people to read and post ideas as they go through the site. See you in cyberspace.

Sincerely,

Carlos “Sabor”