DBNull Error

Am getting errors on this syntax:

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Row.myColumn = DBNull.Value

Value of type 'System.DBNull' cannot be converted to type 'String'

Any ideas? Just want to set the myColumn to NULL.

Thanks

Nevermind.

Row.myColumn = Nothing

dbmail custom header

Is it possible to add custom headers to email sent using dbmail?

I am using bcc to copy an email to a public folder to act as a record of sent emails. Outlook 2003 is displaying this as a post not an email so I can't see who the email was originally sent to.

I think this problem would be solved if I could add the following to the message header:

Code Snippet

Content-class: urn:content-classes:message

Thanks, Richard.

Unfornitually there isn't a way to do that with sp_send_dbmail.