Hi

Sorry if this questions has been beat to death, but I am new to SQL server and I have this problem

I have 7 jobs made up in DTS to transfer data from Foxpro tables via query over to SQL server tables (created using the DTS Import/Export Wizard). Now each one works fine when I run them immediatly, but they do not work when they are scheduled to run, they only do step 1, which is drop the table and create the table but it's not putting any data in them.

The 7 jobs start at 5:00 am at 1 minute increments for each. The connection Microsoft Visual FoxPro Driver is setup using the file DSN option which resides on the same server. "Drive:\directory\directory\myDSN.dsn

Should I use User/System DSN? Instead of the file DSN

The Owner for each job is set to the same thing as when the server is booted

Any Ideas what I'm doing wrong

Thank
Deke

See if this is your problem:


http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a
Scheduled Job


--

Andrew J. Kelly
SQL Server MVP


"Deke" <anonymous (AT) discussions (DOT) microsoft.com> wrote

each one works fine when I run them immediatly, but they do not work when
they are scheduled to run, they only do step 1, which is drop the table and
create the table but it's not putting any data in them.
which resides on the same server. "Drive:\directory\directory\myDSN.dsn"

Thank you Andrew for pointing me in the right direction.