July 2, 2019 at 6:48 am
Hi ,
I have table/procedure/function script in flat file, i'm looking for solution to execute scripts (flat file) in SQL server db using SSIS.
I have tried to use foreach loop - flat tile connection and execute SQL task - seems incorrect. Any help much appreciated, Thank you!
July 2, 2019 at 7:49 am
This seems like a bad idea; having a bunch of files with (unsanitised?) SQL to be run is a big security hole. Who will have access to put these scripts here? What security processes have you got in place to ensure that nothing malicious is put in the files? What permissions will these scripts be run under against your SQL server?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2019 at 6:41 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply