The only way I seem to be able to backup my shared online SQL databases to a local location is to import the data to local SQL copies. I can do this through the Import/Export Wizard and all works just fine. The problem comes when I try to use the local SQL Server Agent to schedule a job. If I manually run the dtsx packages all imports nicely. When I create a job that runs the package it always fails. The failure seems to be because no password is transmitted to successfully connect to the online database. I have a dozen shared online databases I need to back up on a regular basis. When I used Enterprise Manager on the older SQLs I never had this problem. Any and all help appreciated.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.