0

I have one package which loads data from excel using ace.oledb.12.0 driver to SQL server(same server where SQL agent service is running.).

When I ran this Step from SQL Agent using Infrastructure Service account it succeed. When I ran this step using a credential account it is stopping the job as a failure 'Unexpected Termination'.

Funny part is this is running exactly fine for files with data size low(100kb-300kb) when run from both Infrastructure Service account and a Credential account.

But for my current file having size 4.5 mb it is failing via Credential account.

Is there a way I can capture why the job is getting terminated?

desertnaut
  • 57,590
  • 26
  • 140
  • 166
Vlogs Bengali
  • 85
  • 1
  • 13
  • You posted this question [yesterday](https://stackoverflow.com/questions/63395245/unexpected-termination-when-loading-data-from-excel-using-ssis) – Thom A Aug 14 '20 at 12:47

1 Answers1

0

Disclaimer: I work for ZappySys

Looks like you need to find out detailed error message to know more. Did you deploy package using SSIS Project Mode in SSISDB or running as File System Package? When you run SSIS Package via Agent Job you will see very limited error message and many times its useless. So better to run package under SSIS Catalog so you see full execution log. If that is not possible then try to Add Some SSIS Log Provider (see below) for better logging on error messages.

How to add SSIS Log Provider in your package

How to view execution log in SSIS Catalog (See Step#10 in this link)

ZappySys
  • 91
  • 3