Scheduled DTS Package wont run

[puppet]

I have set up a dts package to drop and create a table on an SQL server and populate it with data from an AS400 table. The dts package runs perfectly but when I schedule it it fails with the following error message.

DTSRun: Executing... DTSRun OnStart: Drop table [tms].[dbo].[category3]
Step DTSRun OnError: Drop table [tms].[dbo].[category3] Step, Error =
-2147217887 (80040E21) Error string: Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was
done. Error source: Microsoft OLE DB Provider for SQL Server Help
file: Help context: 0 Error Detail Records: Error:
-2147217887 (80040E21); Provider Error: 0 (0) Error string:
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done. Error source: Microsoft OLE DB
Provider for SQL Server Help file: Help context: 0 DTSRun
OnFinish: Drop table [tms].[dbo].[category3] Step DTSRun OnStart: Create
Table [tms].[dbo].[category3] Step DTSRun OnError: Create Table
[tms].[dbo].[category3] Step, Error = -2147217887 (80040E21) Error
string: Multiple-s... Process Exit Code 1. The step failed.

Any help appreciated