The 'Union' task is a container type task that will perform a UNION ALL to combine the result sets of two or more SELECT statements that have been added to the Union container.
IMPORT [CSV_A] = [CSV data source].{SELECT * FROM [C:\Temp\CSVdata\CSVdataA.txt]}
IMPORT [CSV_B] = [CSV data source].{SELECT * FROM [C:\Temp\CSVdata\CSVdataB.txt]}
IMPORT [CSV_Union]=
[ME].[CSV_A]
UNION ALL
[ME].[CSV_B]
Comments
Please sign in to leave a comment.