Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DTS ERROR

Posted on 2010-09-03
3
Medium Priority
?
531 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

722 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