Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate. Unfortunately I received the following error: The permissions granted to user ‘MachineName\SomeUser ‘ are insufficient for performing this operations. This confused me a bit since my account was an administrator. After digging a bit I found a very simple solution. Right-click on the Visual Studio icon or the Business Intelligence Development Studio icon and click Properties . Then go to the ...
Read More
I have read several articles about deploying SSIS packages. Most focus on using the deployment wizard or simply copying the files and their dependent properties onto the server. For companies with a small number of SSIS packages the later appears to be the method of choice. Recently, I was asked if there was a way to accomplish this without leaving Business Intelligence Development Studio (BIDS). To deploy a package from BIDS complete the following steps: 1. Open your SSIS package in BIDS: 2. On...
SQL Lunch # 5 – Looping Logic in SSIS Speaker: Tim Mitchell Topic: Looping Logic in SSIS Meeting URL: JOIN MEETING ADD TO OUTLOOK CALENDAR Description: Software developers have long taken for granted the ability to run iterative processes by using loop structures in their code. For SSIS developers, these same structures are available through the For Loop and the For Each Loop controls. In this session, we'll review each of these containers and demonstrate how they can be used for repetitive proc...
Topic An Overview of Business Intelligence Location: At Lamar Advertising Wednesday, December 2, 2009 6:00 PM - 8:00 PM Sponsored by: EMC Presenter Brandon McMillon Brandon McMillon is a Senior Solutions Principal at EMC. He has 10 years of experience at Microsoft, working on the Visual Studio & Windows development teams. He was also a Chief Software Architect for a Microsoft Gold Partner before coming to EMC. Abstract: This talk will first examine the current marketplace for Business Intell...