I am importing data from Excel files to SQL Server using SSIS. I have written a package (my first) which almost does what I need, with this exception: I have age data in string format that is generally numeric, with intermittent values like 'about thirty' or 'unknown'. I would like to automate the process of converting these types to NULL. My package currently diverts these rows to a file, and the rest processes as expected. I have to think there is a built-in mechanism for this, but can't quite wrap my head around it. Will someone point me in the right direction? Thanks.Echo Train Nashville TN

How does your package "divert" these rows? Does it redirect errors from a Derived Column or Data Conversion component? If so, you can choose to "ignore" those errors instead. Those columns should get filled with NULL values in error situations then. Talk to me now on

Todd, Yes, they were redirected from a Data Conversion component, so that I could see what was happening. I was clearly prepared to make work where none was needed. I did as you suggested, and am getting the result I was after. Thanks so much.Echo Train Nashville TN