SQL server user access cut down from 8pm - 9am. During this period our SSIS scripts would run to load data(from Oracle/mainframe/Access) to sql, large database(s) & too much data - mortgage information. Data center is at discrete location & users are located throughout US.
Can we do anything to improve this condition. 1. So that SQl users can do their job anytime or at least start 6am - 10pm. 2. Do we need to do load balancing on sql server.
Note: Sql users typically write query for reporting purpose or create SSIS package or use SSRS. Any idea would be appreciated!!