SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2011

SSIS 2012: Project Reference

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…

Read more

1 comments, 3,228 reads

Posted in SQLDownSouth on 24 October 2011

SQL Server 2012 SSIS – Why is my toolbox empty?

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?…

Read more

19 comments, 32,417 reads

Posted in SQLDownSouth on 13 October 2011

SSRS 2008 R2: Implementing Row-level Security

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…

Read more

1 comments, 9,631 reads

Posted in SQLDownSouth on 13 October 2011

SSRS 2008 R2: Show Column Meta-Data in ToolTip

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…

Read more

1 comments, 3,628 reads

Posted in SQLDownSouth on 6 October 2011