Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Package stopped in between and throwing below exception

Status
Not open for further replies.

surendarorion

Programmer
Jun 23, 2015
1
US
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
 
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
 
Add logging to text file to your SSIS it will give you more details on error...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top