Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


SSIS Package stopped in between and throwing below exception

SSIS Package stopped in between and throwing below exception

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

Source Application Error
Category Application Crashing Events
Event 1000
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

RE: SSIS Package stopped in between and throwing below exception

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.


RE: SSIS Package stopped in between and throwing below exception

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close