We run a setup which has SSIS 2008 and SQl 2008 R2 . We run integration packages every night at around 9:30 however our DBA has also set up some backups to run . Now both jobs cannot run during office hours .
1. First problem : The backup is locking the SSIS Job . Is there any way around this ?
2. 2nd Problem :The backup is chewing resources
Any suggestions ?