Ridiculous. I was staring at Visual Studio 2013 in disbelief, looking at the empty Toolbox thinking I missed an installation step, even though all the other functionality of SQL Server Integration Services (SSIS) was working just fine. After doing a little digging (this time Stack Overflow did not help), it turns out that SSIS has […]
Tag Archives: SQL Server
Using Temporary Tables in SQL Statements
Found this to be a really helpful tip from Using Temporary Tables in SQL Statements. I wanted to be able to quickly construct a temporary table within a stored procedure and this was just a super-simple set of examples to get that going. Hope others find it useful as well! Using Temporary Tables in SQL […]
Choosing Bitness Inside Business Intelligence Development Studio
Visual Studio came to a screeching halt when attempting to run an SSIS package the other day, and it turns out that it doesn’t like running in 64-bit, at least when we were using this under Visual Studio 2008. Therefore, here is some help for those frustrated by this (which, incidentally, feels like something the […]
How to Format the Labels in a Pie Chart in SSRS 2008 R2
OK this REALLY made me do a facepalm. I was wresting again with SSRS (Microsoft’s SQL Server Reporting Services), and was just trying to format the numbers in a pie chart. It seemed clear enough: right click on the little numbers in the pie chart and edit the number format. It even displays all the numbers […]