I have a stored procedure that will pass 3 variables to an SSIS task. The task should accept the 3 variables/parameters and insert into two tables. The two tables are fairly large tables which is why I'm using ssis to insert the records. The count of records range from 1K to 600K to 1 millions records at any given time.
What is the most efficient way to execute the task in SSIS? SSIS Execute SQL Task or Data Flow Task with ADO.Net or OLEDB or ODBC?