Home Forums Data Warehousing Integration Services Output multiple SQL query result into excel using SSIS RE: Output multiple SQL query result into excel using SSIS
athi_ssn
Old Hand
Points: 328
More actions
February 12, 2013 at 7:53 am
#1587025
If I split my scripts into 30 different files(1 per file) and use foreach loop container, would it work? Would it work? Can the data flow task grab query from the file?
Please advice.