SSIS Script Source Destination Insert Null Columns

Hi I have an SSIS package that retrieves table data from a database using an OLE DB source component.

This then passes the rows of data to a script destination component.

Within this script my code takes the row data and inserts it into the database (amongst other things).

However I have noticed that if any of the Row columns contain nulls then the component falls over with errors when run like so:

[Back Up Prize Banks [2875]] Error: System.Data.SqlClient.SqlException: Parameterized Query '(@PASId int,@ScriptName nvarchar(17),@LastModified datetime,@Pri' expects parameter @RegenerateXML, which was not supplied. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)

I have solved the problem by checking the column contents before inserting it as follows:

Before:
Command.Parameters.AddWithValue("@RegenerateXML", Row.RegenerateXML)

After:
If (Row.RegenerateXML_IsNull()) Then
Command.Parameters.AddWithValue("@RegenerateXML",System.DBNull.Value)
Else
Command.Parameters.AddWithValue("@RegenerateXML", Row.RegenerateXML)
End If

Which is great but it does turn 1 line into 5 lines. I have 20 parameters which takes up 20 lines of code which will now be 20 x 5 = 100 lines of code.

My question is :

Is there a better way to write this code without having to take up so many lines?

Thanks

Matt.