StatSlice Business Intelligence and Analytics | Business Intelligence and Analytics Dallas | Business Intelligence Training Dallas

SSIS Deploy Error – Access is Denied

Here’s a quick problem I ran into in some recent work and the fix I found.

I had been deploying my solution from my local machine to the development server with no issues. I decided it was time to deploy to the production server, but of course, things never go as planned. I was using BIDS Helper with my deployment (which makes life so much easier), but I got the dreaded “Access is denied” error message while I was deploying. I didn’t know what the culprit could be, so I started down the path of searching for it.

Here’s my error message:

Error : BIDS Helper encountered an error when deploying package LoadGroup_Master.dtsx!
“d:\Program Files (x86)\Microsoft SQL Server\100\DTS\binn\dtutil.exe” /FILE “C:\Users\Documents\Visual Studio 2008\Projects\SSIS Load DW\LoadGroup_Master.dtsx” /DestServer MyServerIP /COPY DTS;”File System\DataWarehouse\LoadGroup_Master” /Q
exit code =6
Microsoft (R) SQL Server SSIS Package Utilities
Version 10.50.1600.1 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Could not create SSIS Service Storage object because of error 0×80070005.
Description: Access is denied.

At least it gave me an exit code = 6. So, I looked that up here.

I find this: The utility cannot resolve the command line because it contains either syntactic or semantic errors.

Well, that didn’t make any sense because I was using the exact same path to deploy to the development server. So, I decide to use my local Management Studio to log into the Production SSIS server. Lo and behold, I get this error.

 
Well…what does that mean? It says something about DCOM and remote connections which leads me to start digging and find this article.

http://msdn.microsoft.com/en-us/library/aa337083.aspx

I followed the steps, and viola, now I can log into the SSIS server and deploy my package.

Problem fixed.

Justin Taylor

Justin Taylor

Justin Taylor has been architecting, building and managing business intelligence projects since 1999, including solutions for several Fortune 500 companies. When Justin joined StatSlice, he was looking for an opportunity to make a major contribution to the company and utilize his technology experience to help clients solve their business problems. Justin has broad experience in data warehousing, business analytics, reporting and dashboards, and data architectures. He enjoys opportunities to speak at technology events, conferences and training. He holds several Microsoft certifications include MCT (trainer), MCTS and MCITP certifications in SQL Server BI, and Certified Scrum Master through ScrumAlliance.org.

Subscribe

You can subscribe to our RSS feed.