Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2012-02-16 : 12:54:22
|
| Can anyone advise what is the best hardware architecture for SSIS? We are looking to rebuild our SSIS environment and our hardware plan is as follows:A server with a SQL Instance installed will be responsible for SSIS execution only. This machine will have powerful CPU and RAM but will be purely used for SSIS execution and processingThe actual .DTSX files will be stored under source control on a seperate fileshare. The jobs that call the .DTSX files will fired from the SSIS execution server.Does anyone have any opinions on this setup or any tips on how it can be improved?Thanks. |
|
|
|
|
|
Best SSIS hardware architecture