Executing Flat file query

  • koti.raavi


    Points: 2752

    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!

  • Thom A

    SSC Guru

    Points: 98653

    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?


    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Davio

    Old Hand

    Points: 313

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply