-
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"
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|