Creating and loading data from a text file
My requirement is
1) to take the table structure and data from source system
2) then create target table and load the data from the source system
This should happen (i.e. creating and loading the data) during each run of the job. Because my source table structure is not constant.
I am trying several options. One of them is take source table structure along with insert scripts into a file i.e. by using "Sql File Output"
But not understanding how to use this file as an input and create the table into the target system and load the data.
Can you help me out pls...