SSIS Connection Mgr , set in SQL Server Config Failing

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply