Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server SSIS Packaage Error Code 1073741819. Expand / Collapse
Author
Message
Posted Wednesday, July 2, 2014 3:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 14, 2014 3:30 AM
Points: 57, Visits: 193
Koen Verbeeck (7/2/2014)
Ravi Chhabria (7/2/2014)
Koen Verbeeck (7/2/2014)
Ravi Chhabria (7/2/2014)
Did you get any solution to this? We are facing same issue when executing package containing multiple Execute Package Tasks.


What does your package logging say?


Below is the log from Application Logs
---------------------------------------------------------------------
Faulting application name: ISServerExec.exe, version: 11.0.3000.0, time stamp: 0x5081b8ff
Faulting module name: ntdll.dll, version: 6.3.9600.16502, time stamp: 0x52c359e8
Exception code: 0xc0000374
Fault offset: 0x00000000000f387c
Faulting process id: 0x1440
Faulting application start time: 0x01cf953f3e54e74a
Faulting application path: D:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe
Faulting module path: C:\Windows\SYSTEM32tdll.dll
Report Id: 30b5a0e2-0157-11e4-80d1-000c292c7547
Faulting package full name:
Faulting package-relative application ID:
---------------------------------------------------------------------


Again, such logging is useless.
You need to either enable logging in the SSIS package or look at the logging of the SQL Server Agent job (if applicable).


Logging is enabled in the package but it appears log are incomplete due to the error. This is with SQL Server 2012 and status of package is "Unexpected Termination".

Post #1588372
Posted Wednesday, July 2, 2014 4:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 12,956, Visits: 10,727
Ravi Chhabria (7/2/2014)

Logging is enabled in the package but it appears log are incomplete due to the error. This is with SQL Server 2012 and status of package is "Unexpected Termination".


So you are in no way having the same issue as the OP.
Maybe you start a new thread for this one.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1588375
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse