Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSIS data conversion error Expand / Collapse
Author
Message
Posted Wednesday, April 30, 2014 2:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:53 AM
Points: 26, Visits: 24
Iam using flat file source,data conversion and oledb destination for data transfer
But Iam getting the error

[BEM(ETA) [161]] Error: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 10.0"
Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done.".


[BEM(ETA) [161]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "input "OLE DB Destination Input" (174)" failed because error code 0xC020907B occurred,
and the error row disposition on "input "OLE DB Destination Input" (174)" specifies failure on error.
An error occurred on the specified object of the specified component. T
here may be error messages posted before this with more information about the failure.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "BEM(ETA)"
(161) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (174).
The identified component returned an error from the ProcessInput method.
The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running
. There may be error messages posted before this with more information about the failure.
Post #1566270
Posted Thursday, May 1, 2014 8:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:27 PM
Points: 222, Visits: 527
Did you look up the error codes? There are usually good pointers attached to them.
Post #1566734
Posted Thursday, May 1, 2014 12:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
How did you configure the OLE DB destination?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1566826
Posted Monday, May 5, 2014 2:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:53 AM
Points: 26, Visits: 24
No This is the detail Iam getting
Post #1567439
Posted Monday, May 5, 2014 2:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:53 AM
Points: 26, Visits: 24
After converting data i data conversion , thats the input for the oledb destination
Post #1567440
Posted Monday, May 5, 2014 3:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
mandir.jain (5/5/2014)
After converting data i data conversion , thats the input for the oledb destination


Did you use fast load in the OLE DB destination? Did you map the columns correctly?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567446
Posted Monday, May 5, 2014 3:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:53 AM
Points: 26, Visits: 24
Previously I was able to ,but when I change the destination data base, it is giving error
Post #1567447
Posted Monday, May 5, 2014 3:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
mandir.jain (5/5/2014)
Previously I was able to ,but when I change the destination data base, it is giving error


How do you change the destination database?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567452
Posted Monday, May 5, 2014 3:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 2:53 AM
Points: 26, Visits: 24
in destination connection manager
Post #1567453
Posted Monday, May 5, 2014 4:00 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 781, Visits: 1,390
if the package is failing in between, like few rows are transferred but got error, that may be due to some data type issue. if this is the issue then you can redirect the defective rows to some other file and check which particular value is causing the issue, these kind of issue do happens when you exclusively convert data especially large strings.
Post #1567457
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse