asked on

Could not save the package to SQL Server

Hi,

I am trying to execute WR_DW_SSIS.SSISDeploymentManifest file to install the packages but get the following error;
"Could not save the package "E:\MSSQL\Database_Backups\DataWarehouse\Deployment\DW_3BuildDIMTables.dtsx" to SQL Server "WTRUATDB02". (Package Installation Wizard).

The deployment ran successfully on once server but not the other. Not quite sure what is going on here. The hostname, paths, username and password ahve been adjusted accordingly.

Thank you in anticipation!

===================================
 
Could not save the package "E:\MSSQL\Database_Backups\DataWarehouse\Deployment\DW_3BuildDIMTables.dtsx" to SQL Server "WTRUATDB02".  (Package Installation Wizard)
 
===================================
 
The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'DW_3BuildDIMTables' is denied.).  The SQL statement that was issued has failed.
 
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
 
===================================
 
The SaveToSQLServer method has encountered OLE DB error code 0x80040E14 (Access to Integration Services package 'DW_3BuildDIMTables' is denied.).  The SQL statement that was issued has failed.
 
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)

Open in new window

SOLUTION