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!

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

SSIS Package which was sheduled thr

Status
Not open for further replies.
Sathia sankar

Sathia sankar

Programmer
Sep 9, 2021
1
0
0
US
SSIS Package which was sheduled through SQL agent getting failed with only error message "Unexpected Termination". The same package when running with small amount of data its is successfull. But when running with large data it getting failed as mentioned before in last step. Have tried running the package from Visual studio development environment with same large Source file and it gets completed successfully(It took 20 min). The issue is mainly with large volume of data when runnning from SQL agent. Any help with this error will be helpful.
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Question
SSIS in SQL Server 2022
Replies
4
Views
136
grnzbra
grnzbra
grnzbra
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
77
grnzbra
grnzbra
TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
80
mark williams
mark williams
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
104
mark williams
mark williams
Igelchen
  • Locked
  • Question
SSIS System.Text.JSON
Replies
0
Views
90
Igelchen
Igelchen

Part and Inventory Search

Sponsor

Back
Top