Getting Started with SSIS

I am relatively new to the world of SQL Server Integration Services (SSIS). I knew sort of what it was and that it existed, but I didn’t start working with it and learning how to use it until about 3 years ago.

I started by following through the Stairway to Integration Services. This is a great way to jump start if you are just starting out. This program assumes you know absolutely nothing about SSIS and walks you through from beginner to a solid intermediate.

It was shortly after completing the Stairway that I began my first consulting job and was heavily working with SSIS. At this job, I was designing and maintaining packages that would grab FTP files, put the information from the files into a table, and push that information to production. Sometimes, they would also grab data from the database, place it in a flat file, and send that file via FTP or SFTP to a client.

This job was also a great way to start with SSIS. I wasn’t doing anything too complicated, and if I ever hit a snag, a quick google search would most likely bring me to a resolution.

It was also in this job, that I met my first “monolith” package. This was a package that was running for over 4 hours at a time and then timing out. The job was to move data from a MSSQL data source into a MySQL data source housed in AWS. My Dad and I worked together on this package and we were able to break it down into smaller chunks – 1 controller package, and a package for each step that needed to run. When we were finished, the whole project ran successfully in less than 18 minutes!

I recently spent some time talking to my Dad about my experience in getting started with SSIS. If you’d like to listen to it, you can find it here.

Hello world!

The very first thing you learn when you are learning a new computer language is how to write “Hello world!” to the screen/output desired. True to that standard, here is my “Hello world!” blog post.

I’ve been working with computers all of my life. I built my first server at the age of 13 with nothing but a box of parts and a book. I taught myself Visual Basic in the same manner. I continued my studies at Liberty University’s computer science program where I was first introduced to relational databases. I happen to love databases and data for that matter. Today, I work as a consultant and do work with Microsoft SQL Server Integration Services, Microsoft SQL Server, MySQL, and anything else that happens to come up. I love learning about new technologies. I currently work with my dad, Andy Leonard, at Enterprise Data and Analytics.

As for my personal life, I am a wife to Antony Trupe. We’ve been married since July 26, 2006. We have three awesome children: Alex, Gabe, and Ellie. We homeschool all three of them for now. I am active in our homeschool co-op as a teacher and the current webmaster for the group. In addition to our kids, we also have two cats (Jack and Ginger), three goats (Rosabell, and her two little boys), a collection of chickens, and thousands of bees. I enjoy baking and making novelty cakes. I also dabble in sewing a little bit. I am an avid coffee drinker as well – my favorite right now is either Joe Bean’s (a local drive thru coffee shop) or Death Wish Coffee.

I’m hoping to use this blog to help spread any knowledge that I have acquired throughout the years, whether it be about computing, baking, animal husbandry, homeschooling, or homesteading. Thank you for visiting!