I am converting our DTS packages that run under SQL Server 2000 to SSIS packages on a SQL2008 server. Many of them are data transformations. They don't migrate properly, so I am converting them to equivalent data flows under SSIS using ADO.net connections (for both source and destination). The bulk work, but I am getting the following error from a few of them: [-cut- [349]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unable to cast object of type 'System.Decimal' to type 'System.Char[]'. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OneUnited Datamart" (349) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (352). 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. I have access to both the source (oracle 9.1) and target (SQLServer2000) databases and I can confirm that in at least one case that the column types between the two tables match. I can even figure out which row caused the failure by ordering the results and selecting from the destination table but nothing in the row stands out. One out of maybe 800 inserted rows may fail with this error when I turn off validation. The queries have a large number (over 50) of columns selected. How can I track this error down?

Hi Luigi According to the error "[-cut- [349]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unable to cast object of type 'System.Decimal' to type 'System.Char[]'." The problem is with casting from Decimal to character type. You have already conveyed the query has over 50 coloumns. Remember the There is two different troubleshooting approach you can take to identify the issue. First Approach ============= First Error : "[-cut- [349]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unable to cast object of type 'System.Decimal' to type 'System.Char[]'." Identify the list of columns at the source which has decimal coloumns and include that coloumns alone in the a new query and generate the new SSIS package to export by this way we will have a less number of cololumns to troubleshoot. We need to ensure that there is a SL NO coloumn at the source and destination table so that when the row export fails we can identify the missing serial number get that row from the source and see which value of the colmn is not able to export . Second Approach ============ based on the second error message Second Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OneUnited Datamart" (349) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (352). The identified component returned an error from the ProcessInput method On this error it is failling at processing the input inside the component "OneUnitedDatamart" remember here it give a number 349 this might be the line number. The same error message also says ADO NET Destination Input" (352) what is this 352 ? Is this the record number ? it says the error message is through by ProcessInput method. When i here method this should be a stored procedure , function. in that case we can trap this error through a debuuger. As a drill drow approach Its better to check each step in the ssis package by enabling extended logging in SSIS to get a detailed error message. To fix this problem it is MOST imporant to understand the package and steps in detail. please let me know whether you can try the first step and also provide more information about the packageMCTS/MCITP (SQL Server 2005, 2008, 2005 BI)