June 4, 2014 at 11:00 am
I have an ssis pkg which uses a SQL Server db table to hold the configurations. When I run the package in VS 2008 it runs fine but when I deplot to the server and execute it from a job (with the Job owner set to my login) I get the following error:
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired"
Since the job owner is my login shouldn't this be used the same way as in when its run in VS 2008?
June 4, 2014 at 11:54 am
Are you running the package from a job on the same machine as you are running VS 2008?
This error isn't a login failure, but a timeout which seems to me to indicate some kind of network latency or connectivity issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply