In SSIS you might have occasion like I did to do a Lookup that needs to match data of different types. Here is the error you may get when you try to map the lookup column. There are a couple of ways you can fix this. One possibility is to convert the data by using the Data Conversion Transformation. The other way is to use CAST in your SQL query for the Lookup (assuming you are using the Best Practice of a SQL query).
Read More
There are a few tasks that I find myself using all the time when I’m on a project using MS Visual SourceSafe. I discovered that you can add buttons to your BIDS environment to suit your needs. Simply right click in a blank area on the menu and select Source Control. This will add all the buttons for Source Control. Then you can click on the drop down button and remove items you don’t want cluttering up your environment. The four I use all the time are Check In, Undo Check Out, Refresh Status, an...
In SSIS it is a best practice to name your Connection Manager the same as your Configuration File. You can save yourself some time by using cut and paste from the following screens taking advantage of Windows slow-double-clicking . Assuming you know how to create Configuration Files, use the Browse button to locate your Configuration File. After browsing to its location, click once to select the Configuration File Click a second time but not too fast to select only the Name without the extension...
My career in Business Intelligence started with the Pragmatic Works Foundation ( Brian Knight ’s gift to the IT community). The five day comprehensive class included training in SQL Server Management Studio and Business Intelligence Development Studio and helped me develop the skills needed to become a professional BI Consultant in one of the fastest growing sectors of IT. The experience for me was truly life changing! When I started my first day at Pragmatic Works I immediately knew this was a ...
You may want to use SQL Server Agent to have a Cube processed as part of a scheduled job. This is how you create the step to process the Cube. After connecting to the Analysis Server, right click on the Cube and select Process. When the process window opens, click the dropdown by Script and select Script Action to Clipboard . Then click Cancel so you will not start processing the Cube immediately. Now open a job or create a new Job in SQL Server agent. In the Job window, click on Steps and New t...
There are times during development when you need to send a package to someone to help troubleshoot a problem or validate some results, etc. Recently, a client got this message when trying to load a package that I had emailed to them. We had been sharing packages back and forth with no problem until this one occurred. As you can see the “Additional Information” doesn’t really give any additional information at all. Apparently this is a very generic message that will occur under a variety of situa...