You will likely need to make sure it has access to c:\windows\temp Also to Arthur's point, there was some much better options than clustering, distributed processing, etc.

I installed SQL SERVER 2008 R2 SSIS service using NT AUTHORITY\NETWORK builtin account. After installation, I decide to change the SSIS service account to an AD account, I change the account in SQL SERVER Configuration Manager. My question is: 1. When I manually cluster SSIS, should I use AD account? is it ok to still use default NT AUTHORITY\NETWORK account? 2. After change the SSIS service account to AD account, what security permission should I grant to this AD account. I know that during installation, the installed automatically grant some kind of permission to service account, so when I manually changed the service account, what should I do to make it same as installer did? Do I need to uninstall and reinstall to make sure the SSIS service account have correct permission? I temporyly grant the AD account as sysadm, my concern is that the sysadm may be too high for SSIS Service account. Thank you very much PAULqaz

I installed SQL SERVER 2008 R2 SSIS service using NT AUTHORITY\NETWORK builtin account. After installation, I decide to change the SSIS service account to an AD account, I change the account in SQL SERVER Configuration Manager. My question is: 1. When I manually cluster SSIS, should I use AD account? is it ok to still use default NT AUTHORITY\NETWORK account? 2. After change the SSIS service account to AD account, what security permission should I grant to this AD account. I know that during installation, the installed automatically grant some kind of permission to service account, so when I manually changed the service account, what should I do to make it same as installer did? Do I need to uninstall and reinstall to make sure the SSIS service account have correct permission? I temporyly grant the AD account as sysadm, my concern is that the sysadm may be too high for SSIS Service account. Thank you very much PAULqaz What do you mean under manually cluster? SSIS is not meant for clustering. #2: The AD account should be able to access local file system at least and the database. No need to re-install.Arthur My Blog

Although SSIS is not meant for clustering, but we still prefer to cluster it, so I manually cluster.PAULqaz