Increase Performance of SSIS Package
Executing 2 SSIS packages independent of each other inside a sequence container. Is this a correct way of doing? works fine but can the performance be increased some how..
Thanks,
j
October 25th, 2011 4:45pm
You're executing in Paralell so there's not much to be gained unless you spawn them as separate processes with dtexec which *may* help.
If you need to performance tune, look at the individual packages
Cheers, JamesJames Beresford @ www.bimonkey.com
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @
SSIS ETL Framework on Codeplex
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2011 9:02pm
You're executing in Paralell so there's not much to be gained unless you spawn them as separate processes with dtexec which *may* help.
If you need to performance tune, look at the individual packages
Cheers, JamesJames Beresford @ www.bimonkey.com
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @
SSIS ETL Framework on Codeplex
October 26th, 2011 3:45am
You're executing in Paralell so there's not much to be gained unless you spawn them as separate processes with dtexec which *may* help.
If you need to performance tune, look at the individual packages
Cheers, JamesJames Beresford @ www.bimonkey.com
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @
SSIS ETL Framework on Codeplex
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2011 3:45am