SSIS Package stopped in between and throwing below exception

[surendarorion]

Date 6/23/2015 11:09:23 AM
Log Windows NT (Application)

Source Application Error
Category Application Crashing Events
Event 1000
Message
Faulting application name: DTExec.exe, version: 2009.100.4290.0, time stamp: 0x520005b9
Faulting module name: dtsmsg100.dll, version: 2009.100.4290.0, time stamp: 0x5200057b
Exception code: 0xc0000005
Fault offset: 0x0000000000001b04
Faulting process id: 0x5d18
Faulting application start time: 0x01d0ad8afa229778
Faulting application path: f:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe
Faulting module path: f:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtsmsg100.dll
Report Id: 27acb80b-197f-11e5-916d-000c29de7607

WGS2 Job Failed. The step did not generate any output. The return value was Unknown. The process exit code was 255. The step failed

 

[Motlatjo]

Hi Surendarorion

Lets first start by debugging.
Include a Data Viewer before the OLE DB Destination and see if the problem is with the Source or the Destination.

The other thing you can do is to preview the data on both the Source and the Destination.

Regards

 

[gk53]

Add logging to text file to your SSIS it will give you more details on error...