I would appreciate if someone can advise me how to get rid of the Script Security popup message box when I run a load script from batch file.
I have checked the Open Database in Read and Write mode in the settings tab. Reason for this is in my script I execute a stored procedure in SQL server that write to a database and this works fine.
My problem is I have schedule the load in a batch file that run in early hours of morning but now the popup box halt the load until I manually click the button give system access in the popup.
Is there a way to avoid this popup message box ?