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