• David when I open the package on a 2005 Dev server it runs but when I try to run it as a job I get the following errors.

    Message

    Executed as user: OTGDEV04\SYSTEM. ...on 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:44:20 PM Error: 2009-06-12 13:44:24.83 Code: 0xC0202009 Source: SQL_Overview_Package Connection manager "MultiServer" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'FNBN\OTGDEV04$'.". End Error Error: 2009-06-12 13:44:24.94 Code: 0xC00291EC Source: Execute XP_MSVER Execute SQL Task Description: Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2009-06-12 13:44:40.69 Code: 0xC0202009 Source: SQL_Overview_Package Connection manager "MultiServer" Description: SSIS Error Code DTS_E_OLEDB... The package execution fa... The step failed.