Cannot get DTS Package to complete as a scheduled Job
From: Paul (paul.boyden_at_anam.com)
Date: 03/25/04
- Next message: Paul: "DTS Package won't run as Job"
- Previous message: M: "Re: Create Access97 table via DTS"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Mar 2004 08:44:01 -0800
I have created a DTS package to do the following:
run a query on a table
send the data to a txt file (approx 200K rows, file size
around 12Mb
run the command line WinZip add-on to compress the file
(to approx 800K)
finally to take the compressed file and email it to
certain users.
When I execute the package it appears to work.
When I create a schedule (3 times a day) the job keeps
coming back as failed. the failure log only indicates
that it had processed 6K-7K records, yet I know the
package worked because the txt file and Zip files are the
correct sizes and have the same time stamps.
Any help in getting to work would be appreciated.
PS, I removed the WINZIP command line part of the package
and the same error occurs.
Regards
- Next message: Paul: "DTS Package won't run as Job"
- Previous message: M: "Re: Create Access97 table via DTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
