Good Day Forum, Thank you for all the support and guidance you have offered. I have a task to extract 'n' SQL Server tables and load them into 'n' Teradata tables , i got the Attunity TD Connector for SSIS , and i'm loading one table at a time, is there any process like a bulk insert? The table names and the structures are the same in both the environments. --Thanks

You want to load the tables in parallel, is this a correct statement? If so you can just create multiple DFTs (Data Flow Tasks) each processing such a table and not to connect them sequentially. But if the number of tables is very big you may want to construct your package so it will load the names of the table from say a variable, but then since you will be cycling through the tables the process is not going to by any fast.Arthur My Blog