I have a simple package with two tasks. The first simply gets a date from an SQL2005 table. The second is a data flow task that transfers data from an ACCESS table to a SQL2005 table. When I run it from Studio it works like a charm. I tried to schedule it as a SQL Server Agent job. The job has one step, the package. The package is stored in a folder (Package Source: File System) on the database server and I use the full path (NOT drive letters) to identify it. When I try to run the job it crashes at step 1, the only step, after 00:00:01!
Any ideas?
TIA
Any ideas?
TIA