In today's blog, I wanted to share information on the Lookup Task. It is a great task because it will take your data Join it together, similar to what a Join does in TSQL. When you pull out the task in the Data Flow, you will need to connect it to an existing task. In the example below, I have directed data to be sent from the condition split to the Lookup. Once inside the Lookup Task, you will need to set a couple of the General settings. Here you will need to decide if you want to select Full,...
Read More
I recently came across an error after I copied some code (see below) and pasted it into a Expression Box. CASE Gender WHEN ‘M’ THEN ‘Male’ WHEN ‘F’ THEN ‘Female’ ELSE ‘Unknown’ END What I found out from Brad Schacht was the encoding on the single ticks is different in the SSIS environment from a Word Document. TO FIX IT: I had to delete each tick and replace it with a new one and was able to proceed. Want to know how to document/take a snapshot of your BIDS environment, click here . Need to migr...
I recently experienced a problem with my mouse when I remoted into a virtual pc. Once logged in, I no longer could use the mouse to navigate my way through the screens. I am sure that a lot of us have struggled with figuring out what the hot keys are until we research it. Which is what I had to do and here is what I found at http://brandonlive.com/2009/01/10/windows-7-beta-hotkey-cheat-sheet/ : General Win+Up Maximize Win+Down Restore / Minimize Win+Left Snap to left Win+Right Snap to right Win+...