Solved

DTS ERROR

Posted on 2010-09-03
3
520 Views
Last Modified: 2012-08-13
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??
0
Comment
Question by:sassy168
  • 2
3 Comments
 

Author Comment

by:sassy168
ID: 33600924
even when i manually run the dts itworks just fine.!!
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33601237
First of all this is not an error it is a Warning:
Warning: Null value is eliminated by an aggregate or other SET operation.  

That is why when you "manually run the dts itworks just fine",  you are not seeing the warning message.

What is happening is that you are using a GROUP BY clause and it contains NULLs.
0
 

Author Closing Comment

by:sassy168
ID: 33784365
yes
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now