CODEWITHSUNDEEP
sql-servert-sqlstored-proceduresssissql-server-2008-r2
vision
vision

Reputation: 455

SSIS Package is not running from stored Proc?

I have a SSIS Package when iam trying to execute from SP iam getting wiered error but it was running fine from MSBI.

Sp is 

EXEC @intErrCode = master..xp_cmdshell 'dtexec /sq Loadnewtables /De 99999'

Output is 

but I keep getting the following error:

Could not load package "My_Package" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x
004005 (Login timeout expired). The SQL statement that was issued has failed.

Upvotes: 0

Views: 1123

Answers (3)

dragonspeare
dragonspeare

Reputation: 41

Could be related to this bug report - there is a sp in the SSISDB database in SQL Server 2012 causing packages to time out before they start running. I had error message "Failed to execute IS server package because of error 0x80131904" and "Description: The operation failed because the execution timed out" when calling multiple (more than 10) packages from my scheduling tool via DTExec. Please vote for the issue on the connect site so that MS can release an official fix.

Upvotes: 1

Maverick
Maverick

Reputation: 1185

I think there is an user/password issue. It might be due to following issues: - Check your right on the server. - Check your authentication mode ( window/user) - Trying run locally.

Upvotes: 1

Anup Shah
Anup Shah

Reputation: 1254

Well error is very self-explanatory. When you load package from DB, and do not use “/User” and “ /Password” options, windows authentication is used to load that package. So that brings up check needs to be done around users and permission. Check the windows user exists with right permission.

I am assuming you are on the same machine where this DB is located. For instance you have the DB server where this DB is with the package and you login to your local machine and connect to SSMS to execute this. this will result in trying to load package using windows login that you logged in in to your local machine. which might not be exists on the DB server (let’s say you do not have full access to that server.) So to make it simpler on testing side call with SQL authentication method and see how it goes.

Upvotes: 1

Related Questions