yanci1179
asked on
SSIS parallel question SQL Server 2008 R2
I have a database server and SSIS server (separate servers)
If I call 1 store procedure 6 times using sqltasks within my SSIS package that is stored on my SSIS server, will it use the resources of the database server or SSIS server to do the parallel processing?
If it runs on the database server, what are ways to push the load to the SSIS server?
If I call 1 store procedure 6 times using sqltasks within my SSIS package that is stored on my SSIS server, will it use the resources of the database server or SSIS server to do the parallel processing?
If it runs on the database server, what are ways to push the load to the SSIS server?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER