BI parallel execution
Hi All,
Currently facing a issue with SSIS BI Package.
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software.
SSIS packages use a visual development tool based on Microsoft Visual Studio called the SQL Server Business Intelligence Development Studio (BIDS).
We are using this SSIS to extract data from Oracle 10.2.0.4 server. We intend to parallelize the operation.
When we run the query /+ parallel (table_name, degree */ in Oracle, its running fast.
When I put the same query BIDS studio, it doesn't save.
I need to run the query from SSIS package in parallel mode.
Appreciate help on how to do it.