One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task. Open the Execute Package Task Editor and select Package from the left window. Select Project Reference for the ReferenceType property. Now you can reference any package that exists in the same project. Just click the drop down list labeled PackageNameFromProjectReference and select the package from the list. This is especially useful when building Master...
Read More
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed to open my toolbox, of course I went to the menu bar selected View > Toolbox. To my surprise the toolbox was completely empty. What the #$%#? What to do? Well it’s actually pretty simple. Located on the top right corner are two icons. The first opens the variables window and the second opens the SSIS TOOLBOX . Nice, I like it. If your toolbox is empty, don’t worry it’s...
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there are a couple of solutions that can be used to quickly and easily resolve the problem. First, you could follow the steps in this whitepaper, Implementing Row and Cell Level Security in Classified Databases . In addition, you can use the SQL Server Label Security Toolkit to assist in the configuration. On the other hand, if your implementation does not ...
First, I want to apologize to the three people that read my blog. Sorry for going dark for such a long period of time. I am not going to commit to writing on a regular basis just yet, but I will be back consistently soon. Enough about me, let’s talk about the problem at hand. Recently, someone asked if it was possible to show column information (description, data type, etc…) in a tooltip. I never really gave that scenario much thought until I was posed with the question. So, is it p...