THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

SSIS 2005 on Windows 7

Introduction

I recently upgraded from Vista Ultimate (x64) to Windows 7 Ultimate (x64). So far I really like Windows 7, but I'm still in the honeymoon phase. I ran into an issue creating new packages using SSIS 2005 and found a solution I thought I'd share.

The Error

Unfortunately for both of us, I did not capture a screenshot of the error. I can tell you it occurred when I created a new SSIS project or attempted to add a package to an SSIS project. The text of the message read something like:

"Cannot create package" and " failed due to the following error:"

Now I know on the surface the text above is utterly meaningless. My fervent hope and desire is that search engines will catalog this page so people encountering the same error can find it when searching. Because frankly, I didn't find anything online that helped me figure this one out - it was all trial and error and, in the end, dumb luck that worked for me.

If you encounter this error, please capture a screenshot and/or the text of the error message and leave a comment to this post. I promise I will contact you and update this post so it's more accurate. Since I fixed it, I've been unable to reproduce the error.

The Solution

Run As Administrator. Simple, eh? Like searching for my car keys, the solution was in the last place I looked.

To set this permission on the Business Intelligence Development Studio application, click the Windows button and navigate to the All Programs\SQL Server 2005 folder. Right-click the Business Intelligence Development Studio object and click Properties:

Once Properties display, click the Advanced button on the Shortcut tab:

 

 When the Advanced Properties dialog displays, check the "Run as administrator" checkbox (NOTE: This assumes you are a member of the local Administrators group on your workstation):

Click the OK button to close the Advanced Properties dialog. You will be prompted to confirm these changes. If you are a local administrator on your workstation, you can click the Continue button and move on. If not, you will need a member of the local Administrators group to login to your workstation and validate this change:

 

Click OK to save the changes to Properties.

After I made this change to my shortcut, I was able to create SQL Server 2005 Integration Services packages on my Windows 7 machine.

:{> Andy

Published Monday, September 28, 2009 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AlunJD said:

As you can't re-create it (I assume you have tried)

then it may have needed admin to install something (DLL Reg stuff)

once done it does not need it anymore.

September 29, 2009 11:05 AM
 

Will Riley said:

Similar to issues we had when first using BI elements on Windows Server 2008... the "run as administrator" issue is common, which kinda makes sense, however frustrating when you initially encounter the issue ;-)

http://wills-blog.com/?p=219

Kind regards,

Will

October 4, 2009 3:30 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement