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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics