Hi, When I ran the 2008 SSIS package I am getting error at Script component (Script Component: RunTime Error The column has NULL Value). at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.CheckStatusAndNull(Int32 columnIndex) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetInt32(Int32 columnIndex) at ScriptComponent_14ee8da369a64bce8aff81b1e175b6b0.vbproj.Input0Buffer.get_RedemptionItem() at ScriptComponent_14ee8da369a64bce8aff81b1e175b6b0.vbproj.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) at ScriptComponent_14ee8da369a64bce8aff81b1e175b6b0.vbproj.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) at ScriptComponent_14ee8da369a64bce8aff81b1e175b6b0.vbproj.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) Please Suggest the best way to handle the NULL values in Script component (like is there any setting which can allow NULL values in Script component OUTput Buffer). Thanks in advance Srini srinivas

For each of your output columns, there should be a property you can set called ColumnNameIsNull or ColumnName.IsNull (you can find it with intellisense). Set that to True instead of trying to assign a NULL value to your output column.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Thanks for the reply. I am not able to the option in "Script component". Can you please guide me where to look for the setting. Thank you Srinisrinivas

It would be found when coding. Start typeing the name of one of your columns and when intellisense pops up a list of closely named items, look for one with "NULL" at the end. This is a boolean property you can set and it essentially assigns NULL to the particular output column.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.