I need help to execute a taxk.
I have text file which has SQL Statements something like
Select top 10 * from Table 1
Select top 10 * from Table 2
Select top 10 * from Table 3
Select top 10 * from Table 4
I want to create a package which has to execute all the sql statements and return all the output in 4 different flat files.
Quick questions, are all the source tables the same structure? Do all the queries return the same structure? Are all the destination flat files of the same structure? Is the statement file a prerequisite for the operation or only the statements? Will the statements change in any way shape or form from one run to another?