Hi there: I have a csv file and a column called [Intended Priority] which contains numeric value. In the DFT, I added a flat file source for this csv file and when I opened the advanced editor, this column is string [DT_STR] Now , I'd like to dump the values of this csv into an access table and the corresponding column in access table is called [Priority] and it's [DT_I2]. What I did is to add a derived column between source and destination and put the expression of (DT_I2)[Intended Priority] for a column called [converted_intendedPri] However, it gives me the following error: [Derived Column [152]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (152)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "converted_intendedPri" (491)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Any ideas about this? thanks Hui --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

(DT_I2)TRIM([Intended Priority]), may be you are getting blank spaces. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

tried it and still the same error [Derived Column [152]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (152)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "converted_intendedPri" (491)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. I've checked the raw csv file and that column did contain "" instead of numbers.--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

Can you try to configure error op for the derived column and check the failing records using a data viewer?Nitesh Rai- Please mark the post as answered if it answers your question

What should be written to the table in case of ""? try len(TRIM([Intended Priority])) > 0 ?(DT_I2)TRIM([Intended Priority]) :0

thanks christa, I tried your solution and it did work. It should be 0 if the column contains "". Hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --