Hi, I have source which will read data from neoview server so i user ADO NET source. I need to transfer the data to sybase database and i using ADO NET Destination. So for this activity i have created the ODBC connection neoview and sybase. i have a package which will transfer the table from neoview to sybase. but when i run the package in the destination side i m getting error like this [ADO NET Destination [678]] 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[]' Pls help me on this. Regards, Thyahoo

It may be possible to solve this issue by applying a Data Conversion Transformation component in between the source and destination. Converting to DT_STR must work, but not sure. For your reference: SSIS Data Types.Arthur My Blog