This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 94%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
I have developed SSIS package which exports data from SQL server to an excel file(.xlsm). There is only two tasks in the SSIS package - 1st task is to copy the template of the excel file and the 2nd one is the DFT to load from sql server database to that template excel file. After I deployed the changes to prod, it ran fine without any issue. Then I had to change the SSIS parameter(location where we extract the file). I updated the folder location in the configuration table but didn't change anything on the package. After I updated the export location, the package started to fail in Prod with "Unexpected Termination" Error message. However this package runs fine in lower environment with the same folder change as in prod. Also when I run the package manually in prod from Visual studio, it runs without any issue.
Any idea why I am getting Unexpected Termination error? Is it because I changed the parameter value in the configuration table but didn't change anything on the package itself? Is there any way to get the detail error message?
Thanks in advance
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You can refer to this document: Integration Services (SSIS) Logging.
If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
Thanks Aniya for your answer. But the error msg is already logged in the SSIS db in catalog but its not providing me much detail other than "Unexpected Termination" error msg. How can I debug this issue? I am not able to replicate the issue in lower environments to make any changes.