64-bit, 32GB RAM

The error is in SQL Job history and I understand its meaningless. Also, it shows in job history with Exclamation point, not the red cross. When i expand, I can see 3 steps, second one shows failed

Message

Executed as user: domain\User. The step failed.

and this is from the log:

Started: 7:26:28 PM

Error: 2013-09-07 19:29:42.43

Code: 0xC020824E

Source: DFT Load DimAccount PreMerge Lookup stage_AccountParcelAddressMap to get APN [6279]

Description: OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties.

End Error

Error: 2013-09-07 19:29:42.50

Code: 0xC004701A

Source: DFT Load DimAccount PreMerge SSIS.Pipeline

Description: component "Lookup stage_AccountParcelAddressMap to get APN" (6279) failed the pre-execute phase and returned error code 0xC020824E.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 7:26:28 PM

Finished: 7:29:52 PM

Elapsed: 204.143 seconds

Microsoft (R) SQL Server Execute Package Utility

Version 10.50.2500.0 for 32-bit

Copyright (C) Microsoft Corporation 2010. All rights reserved.

Thank you very much for you reply