i am getting this error when i schedule to run this DTS package but no error when i am running it in sql analyzer.
Executed as user: IDDB01\SYSTEM. ...xecuting... DTSRun OnStart: Drop table Results Step DTSRun OnFinish: Drop table Results Step DTSRun OnStart: Create Table Results Step DTSRun OnFinish: Create Table Results Step DTSRun OnStart: Copy Data from Results to Results Step DTSRun OnError: Copy Data from Results to Results Step, Error = -2147217900 (80040E14) Error string: Warning: Null value is eliminated by an aggregate or other SET operation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 8153 (1FD9) Error string: Warning: Null value is eliminated by an aggregate or other SET operation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider 'SQLOLEDB' reported an error. The provide. The step failed.
any ideas why this is happening??