August 5, 2009 at 9:11 am
I have Data Collection running on my SQL-2008 instance (version 10.0.2531), but I keep getting the following error in the Query Statistics Collection Set:
Date8/5/2009 11:00:03 AM
LogData Collection (Query Statistics)
Log ID4698
SourceQueryActivityUpload
Collection Set Name
Collection Item Name
Status
Runtime Execution Mode
Start Time8/5/2009 11:00:03 AM
Last Iteration Time
Finish Time8/5/2009 11:00:03 AM
Duration (ms)
Operator
Package Execution ID
EventOnError
Data Code-1071636471
Message
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E57.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E57 Description: "Arithmetic overflow error converting expression to data type int.".
Anyone else seen this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 17, 2009 at 11:04 am
Yes, I also have this problem. This is a known bug with SQL Server 2008. You need CU#5 or greater.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=484224
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy