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

  • Thanks you ..

    I got the issue now . In the configuration file , connection string was defined for Windows authentication . Since I am logged in and running through the management studio its works . But on SQL job its doesn't use windows authentication hence failed . As solution i have configured my connection string with SQL Authentication and worked well.:-P