I recently came across a situation where I needed to find all fields in a database that contained a particular word. All the fields that were labeled Indicator were being changed to Flag. For instance, ActiveIndicator was changing to ActiveFlag. The first part of the challenge is finding all those columns. Luckily there is a way to query the metadata of your databases. There are several ways to do it; I will just show you two methods to do this from inside management studio. First Method: SELECT...
Read More
This blog series will cover SSIS from the group up; beginning with the BIDS environment and going all the way through package deployment. Please feel free to message me or email me if there is a specific topic you would like addressed. Tune in each week to see the next step in the SSIS journey. Welcome to SSIS from the Ground Up Part 3: Connection Managers. This week in our series we are going to be talking about connection managers (yes, I know that is very redundant, but I wanted to make sure ...
This blog series will cover SSIS from the group up; beginning with the BIDS environment and going all the way through package deployment. Please feel free to message me or email me if there is a specific topic you would like addressed. Tune in each week to see the next step in the SSIS journey. ___________________________________________________________________________________________________________________________ The control flow is the portion of the package that shows when you first open a ...
I ran into an issue yesterday that turned out to be a small topic, but very important. The package that I had created was a group of loops to bring in files for an import process for the client I was working for. The files were compared to a list in a database and then processed. If there was no match found the files would be moved to an alternate location, an administrator notified and the process would start over 1 minute later. The problem occured when new files were added to the file system....