-
by David Leibowitz
| March 27, 2008
|
When using the Script Transformation Editor in SQL Integration Services, you might want to pass in more than 1 variable to your script. Properties exist for ReadOnlyVariables and ReadWriteVariables, much like the Script Task Control Flow component. But there is one BIG difference. You may be used to syntax for multiple variable listings in the Control...
-
by David Leibowitz
| March 27, 2008
|
I received this error message during model deployment: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) To fix, I launched "Reporting Services Configuration Manager" On the Initialization (which did have a green check mark) page, I noticed two IDs, one had a check and the other did not. After attempting...
-
by David Leibowitz
| March 14, 2008
|
Create a new web part page in SharePoint and find it lacking the global site navigation? Here's how to fix it: http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/09/18/new-web-part-pages-created-without-side-navigation.aspx Updated Method Here: http://jetlounge.net/blogs/teched/archive/2009/01/12/quick-launch-bar-navigation-missing-from-web...
-
by David Leibowitz
| March 05, 2008
|
Expressions in SQL Server Integrations Services 2005 are extremely powerful. You might use them to dynamically concantenate strings, for example, when you want to write, import or export to various files at run time. But try as you might to use an algorithm like: @User::FolderPath + "\" + @User::FileName it just won't work. You'll...
-
by David Leibowitz
| March 04, 2008
|
How annoying is the beep beep beep in Microsoft Virtual Server 2005 R2? My colleagues are ready to wring my neck everytime I make a systems change. To stop a virtual machine from generating a beep sound when an operating system event occurs, follow these steps: 1. On the virtual machine, click Start, click Run, type regedit in the Open box, and then...
-
by David Leibowitz
| March 03, 2008
|
I received this error on a vanilla install of MOSS 2007 (Microsoft Office SharePoint Server) Enterprise with the sample BI dashboards. To fix: 1. In SharePoint Central Administration, go to 'Manage this farm's shared services' 2. Select your shared service. (Default is SharedServices1) 3. In 'Excel Services Settings' select Edit...