troubleshooting Question

DTS ERROR

Avatar of sassy168
sassy168 asked on
Microsoft SQL Server
3 Comments1 Solution606 ViewsLast Modified:
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??
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros