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 Mike Lewis 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

Programmer
Sep 9, 2021
1
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.

Part and Inventory Search

Sponsor

Back
Top