(Chris) If you have a very large set of data or lots of files that you want to move every night, say because of thousands of flat files or terabytes and terabytes of data, having SSIS on one server just churning away most likely isn’t going to give you the performance you need.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help