Guys, this is what the log output says

Started: 10:06:21 §£

Error: 2008-09-26 10:06:22.48

Code: 0xC0202009

Source: ERP_Import Connection manager "PC-SRV-ERP_HR\ERP.TRANSIT.mis"

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 'INTERFRANCHISE\PC-SRV-MIS$'.".

End Error

Error: 2008-09-26 10:06:22.48

Code: 0xC020801C

Source: ERP Sales OLE DB Source [1]

Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PC-SRV-ERP_HR\ERP.TRANSIT.mis" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

End Error

Error: 2008-09-26 10:06:22.48

Code: 0xC0047017

Source: ERP Sales DTS.Pipeline

Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

End Error

Error: 2008-09-26 10:06:22.48

Code: 0xC004700C

Source: ERP Sales DTS.Pipeline

Description: One or more component failed validation.

End Error

Error: 2008-09-26 10:06:22.48

Code: 0xC0024107

Source: ERP Sales

Description: There were errors during task validation.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 10:06:21 §£

Finished: 10:06:22 §£

Elapsed: 0.563 seconds

Any comments? 🙂