Home Forums SQL Server 7,2000 SQL Server Agent Error - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D RE: Error - SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D

  • yes. you can create a credential with windows credentials, and then a proxy in SQL agent.

    with that in place, you can modify the job step that calls the SSIS package to use that credential instead of the default.

    here's a decent article on how to set it up:

    https://www.simple-talk.com/sql/database-administration/setting-up-your-sql-server-agent-correctly/

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!