Dts!

Expand Post »

Hello Everyone,

I have a DTS package, which has been working fine for few years. it runs once a month to get information from different databases and save it into the destination database. Now I get this error:

error source: microsoft ole db provider for sql server
error description: could not get the data of the row from the ole db provider 'MSOLAP'.
Conversion failed because the data value overflowed the data type used by the provider.
OLE DB error trace[OLE/DB provider 'MSOLAP' IRowset::GetData returned 0x40eda: Data status returned from the
provider:[COLUMN_NAME=[Measures].[The profit]STATUS=DBSTATUS_EDATAOVERFLOW], [COLUMN_NAME=[Measure].[Hours T2]

Any help will be apreciated!

Similar Threads

DTS Package in C#
Dts in MS SQL
Capturing returnValue from DTS package executed from vb.net in VB.NET
Run *.dts from T-SQL proc changing connection parameters in MS SQL
Multi-threading with C++.NET in C++

Ayati

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: SQL 2000 - getting data from two databases, same server

Next Thread in MS SQL Forum Timeline: Data Set and retrieve data in WD

DaniWeb Message

Cancel Changes

User Name
Password