DTS Scheduled Task

Hello,

I'm new to SQL so this should be an easy question. All i want to do is create a recuring task. I want to copy data from one SQL server to another. I've created a package to accomplish this and when i execute it manually it works. What doesn't work is scheduling to execute a regular intervals. As a test i set it up to execute every minute every day (This however will change to once a day when i prove it works) and for some reason it never executes. Any ideas? By the way i created the package using the DTS export wizzard.

Did you create a job via the SQL Agent to do this? Make sure your job is performing an Operating System Command, and that it uses the dtsrun command, something like this:

DTSRun /S YourServerName /E /N "YourDTSPackageName"

Thanks, i'll try that