Executing Flat file query

  • koti.raavi

    SSCrazy

    Points: 2677

    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: 98207

    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.

  • 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