This example takes a series of tables in a large database and extracts them into individual files.
You can do this by creating a two- task VI script.
                                                     
                                                
In the first task, iterate, you list the table names with a  List input object.
List input object. 
TIP: The column heading here gets set as a parameter in the Iterate object.
After the list object, add an  Iterate output object and  create a parameter  for the table names.
Iterate output object and  create a parameter  for the table names.
The second task, extract table, extracts the individual tables with an  SQL input object, by using the parameter set in the Iterate object (table_name) as the Sql_Table name.
SQL input object, by using the parameter set in the Iterate object (table_name) as the Sql_Table name. 
The  Fileout output object is used to define individual files by setting the output file name with the parameter.
Fileout output object is used to define individual files by setting the output file name with the parameter.
When you run the script, it iterates through for each row in the List input object of the first task and writes out a  file for each row.
file for each row.
 
                                                 
                                                 
                                                 
                                                