Open File – Security Warning in SSIS

When running packages that contain executable and batch files you may sometimes come across an issue where you need to confirm that you want to open the file. This can cause an issue if you run the package unattended.

Obviously, this is a security precaution that is built into the many of the newer versions of windows.You have to authenticate sessions, run as administrator, and confirm that you want to open and run a file that could possibly pose a security risk. We know that we want this file to run so we can tell Windows that we do not want to be warned about this any longer. Many times simply adding your local host to the trusted sites in Internet Explorer will solve this issue. If it is a file being run from another network machine, you can add that machine’s IP address as well.

Please note that doing this will cause you to not be warned before you run .bat, .exe, etc. files, so this can pose a security risk if you are not careful. This works more often than not. However, there was an occasion when the server I was working on was locked down a little more and this was not quite enough to fix the problem. If you are still prompted to allow the program to run you can edit the group policy to not prompt you before running certain file types.

To edit the group policy go to Start > Run > Type in gpedit.msc to open the group policy editor. From there expand User Configuration Administrative Templates > Windows Components Attachment Manager. Next set –Inclusion list for low file types- to Enabled and enter the file types you don’t want to be warned about in the box (for instance, .bat or .exe).

Next time you run your packages you won’t be asked if you want to run the file, it will do it automatically!

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me