when i deploy with the deployment manifest (SQL deployment) on my local machine to the server I receive the error TITLE: Package Installation Wizard ------------------------------ Could not save the package "\\path\packagename.dtsx" to SQL Server "server". ------------------------------ ADDITIONAL INFORMATION: The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'packagename' is denied.). The SQL statement that was issued has failed. ------------------------------ The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'packagename' is denied.). The SQL statement that was issued has failed. ------------------------------ BUTTONS: OK ------------------------------ when i copy the files to the server, remote in and run the manifest it succeeds what do i need to change to enable me to deploy from my machine? I guess I have to grant access to something for some user name. any help? Thanks

Can you access the \\path share? Also you need to run BIDS as an Admin.Arthur My Blog

Can you access the \\path share? Also you need to run BIDS as an Admin. Arthur My Blog yeah i can access, I have admin access. I dont know if you are familiar with BIDs helper but I can deploy with no problem using that Is there a way i can find out what user deploymentmanifest is running as when i attempt to deploy using it, and what action it is performing to cause fail.

Hi jameslester, The issue is caused by the users are coming in remotely and they don't have permissions to connect to the SQL Server Integration Services(SSIS). In order to solve the issue, please follow these steps: Check the DCOM permissions, and make sure the users have permissions to the MSDTSServer component per http://msdn.microsoft.com/en-us/library/aa337083.aspx If step 1 doesn't help, add the users to local SQLServer2005DTSUser$ group. If it still not help, please check users' permissions in the SQL Server database engine. Make sure they can save package to the server. If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT