Dump data by reading and executing queries from multiple .sql files.

• akash_singh

  Ten Centuries

  Points: 1089

  More actions

  October 14, 2016 at 7:17 am

  #318148

  Hello All,

  I have a folder that contains multiple .sql file. Each .sql file has query in it. File count may change.

  Output (Output format) of the query in each file is different.

  I want to create SSIS package to read query from .SQL file and execute on SQL Server database and store the result in individual excel file. Number of excel files should be equal to number of .sql queries. Output of every query should be stored in separate excel file. Name of the excel file should be same as name of .sql file.

  Any idea/help/suggestion is highly appreciated.

  Thanks,

  Akash