Hi,
I have created a data transformation job (local package) withing SQL Server 7.0 to export a SQL Server database to a local Access database. The Access tables are dropped, created and then the data copied (there are 170 tables to be transferred). This part works fine when executed directly from the local package. However, when I schedule the job under SQL Server Agent and execute the job from there it never finishes. The Access tables are dropped, recreated and the table data copied to access, it just never shows the job as being completed. Any ideas?
Thanks,
Michael A. Martin
I have created a data transformation job (local package) withing SQL Server 7.0 to export a SQL Server database to a local Access database. The Access tables are dropped, created and then the data copied (there are 170 tables to be transferred). This part works fine when executed directly from the local package. However, when I schedule the job under SQL Server Agent and execute the job from there it never finishes. The Access tables are dropped, recreated and the table data copied to access, it just never shows the job as being completed. Any ideas?
Thanks,
Michael A. Martin