I encountered a problem using the Script Component (used in dataflow), when used as a transform. This component allows you to add output columns, but the datatypes of these colunns do not allow nulls. Is there a 'trick' that will allow these columns to accept nulls?
BTW. I posted to the [SQL Server 2008 - General] forum because there doesn't seem to be a forum dedicated to SQL 2008 SSIS.