April 17, 2009 at 8:17 am
I have imported the SSIS package within IntergrationServices
When I create a Job and select "SQL Server Intergration Services Package" I cannot then select the package, I get the following error:
TITLE: SSIS Execution Properties
------------------------------
An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed.
------------------------------
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed.
April 17, 2009 at 10:12 am
The error that u get is that the user who is trying to run the job does not have access to enumerate (view definition\execute) packages from msdb, or does not have permissions on procs sp_star_job, sp_stop_job etc.
Make sure u understand the permissions model of executing SSIS packages with a Proxy (mapped to credential - AD account).
Let me know if u need any more help on this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply