Good morning,
Wondering if I could get some opinions on a setup for an ETL environment with hardware that has been provided. The client has setup a ETL box and a DB box.
He would like the ETL box to handle most of the processing as far as installation of the package.
Running of the ETL SSIS package through SQL Server Agent from the ETL box and the DB server just to be the recipient of the data. All files would be processed off of a share.
Does anyone have any insight, websites, and or suggestions on best practices and things to look out for regarding a two server setup with ETL.