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 Principal Program Manager on the Microsoft Fabric product team based in Jacksonville, FL. Bradley is a former consultant, trainer, and has authored 5 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. 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

Bradley Schacht

Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Jacksonville, FL. Bradley is a former consultant, trainer, and has authored 5 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. 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