SQLAgent won't complete jobs that require network connections
Posted on 2007-09-28
I have been developing a data warehouse with SQL Server 2005 Standard running on a Windows 2003 server. I have created several packages using SSIS and they run fine within Visual Studio and using the DTExec program. But when I try to schedule the package as a job, the job fails. I have looked over many postings about issues regarding permissions but have not found the answer. Only jobs that require network resources fail. Ones that don't run fine. I am currently using a proxy to run the jobs on a Windows Domain account that has all the permissions. This same account is the one I use to login to SQL Server Management Studio. The scripts run fine on there. The error I am getting says that the network data source path is invalid and does not exist when it actually does exist and works perfectly fine when run in Visual Studio. All the package does is extract information from an Access database on a networked drive.
Any insight on this problem would be much appreciated.