There are many occasions where you will want to update a table in your data warehouse by adding new records and updating existing records. Now, there are a number of ways that this can be done, and these methods all have their pros and cons. The option I'm going to cover is using a merge statement within an Execute SQL Task (or a merge within a stored procedure that is executed by an Execute SQL Task). You will need to create a stage table, preferably in a stage database if you have one created....
Read More
In preparing my blog last week on Passing date parameters to DB2 in an OLE DB source , I ran into an issue in BIDS that I didn't really address at the time, but I thought that it might be helpful to share a solution to this pretty common problem. Once you have set up your stored procedure that gives you your SQL query output and created your variable that will hold the SQL query, you have to configure the OLE DB source using the Advanced Editor. Well, you might notice that when you open the Adva...
As we found out from Devin Knight's blog, SSIS - Data Provider Does Not Allow Parameters in OLE DB Source , we know that we cannot pass any variables to DB2 in an OLE DB source. However, in the event that you need to pass date parameters to a data source, here is an example that is relatively easy to mimic and will only require the creation of one stored procedure in addition to some commonly used SSIS components. To add a date parameter that will pull back the last week's worth of sales data, y...
I don't know about you, but for some reason, one of the most terrifying experiences for me is interviewing for a new job. There are a few things that you can do to prepare yourself for an upcoming interview and make it slightly less terrifying. You can work on improving your communication skills and managing whatever nervous habits you may have developed over the years. Or spend some time thinking of some questions that you would like to ask your hopefully-soon-to-be employer, so that when they ...