I have a requirement to connect to an external system get all the data and load to a import table and eventually doo a transform map. What is the best way to accomplish this? How can I import all the data into a temp table?
Do you need to create the transform map? If you can just download the records and save them to the table, the complexity of your problem might be reduced considerably.
