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

AuswayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HainKurtSr. System AnalystCommented:
check the permissions to execute that procedure, looks like a executre permission is required
0
AuswayAuthor Commented:
Are you referring to the SQL Server or local admin permission on the Server?
0
HainKurtSr. System AnalystCommented:
permission for this "The hostname, paths, username and password ahve been adjusted accordingly."
0
AuswayAuthor Commented:
Thanks for your help HainKurt,

the package deployed successfully. However, now when the package is executed via a scheduled task, the job runs successfully but  nothing happens, executes in 29seconds instead foo 18mins. The package does not seem to follow the control flow of the package.
Any help would be much appreciated & thank you in anticipation.




Date		29/05/2009 6:00:00 AM
Log		Job History (RunDataWarehouseBuildDaily)
 
Step ID		1
Server		WTRUATDB02
Job Name		RunDataWarehouseBuildDaily
Step Name		Step_1
Duration		00:00:29
Sql Severity		0
Sql Message ID		0
Operator Emailed		
Operator Net sent		
Operator Paged		
Retries Attempted		0
 
Message
Executed as user: WTRUATDB02\SYSTEM. ...00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  6:00:00 AM  Progress: 2009-05-29 06:00:25.56     Source: pop_staging_BANKACCOUNTTABLE      Executing query "USE [DSE_WaterRegister_DW_STAGING]  ".: 25% complete  End Progress  Progress: 2009-05-29 06:00:25.56     Source: pop_staging_BANKACCOUNTTABLE      Executing query "/****** Object:  StoredProcedure [dbo].[sp_pop_sta".: 50% complete  End Progress  Progress: 2009-05-29 06:00:25.56     Source: pop_staging_BANKACCOUNTTABLE      Executing query "SET QUOTED_IDENTIFIER ON  ".: 75% complete  End Progress  Progress: 2009-05-29 06:00:28.70     Source: pop_staging_BANKACCOUNTTABLE      Executing query "-- =============================================  -".: 100% complete  End Progress  Progress: 2009-05-29 06:00:28.70     Source: pop_staging_BANKACCOUNTTRANS      Executing query "USE [DSE_WaterRegister_DW_STAGING]  ".: 25%...  The package executed successf...  The step succeeded.

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.