Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Errors in the script task in SSIS packages

Author  Topic  xiPhone Starting Member 1 Post Posted - 2011-09-21 : 09:03:04 Hi All, We were running sql 2005 and had migated to sql 2008, during running SSIS package we got an error in the script task as follow Script Component has encountered an exception error in user code: The column has a null value. at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.CheckStatusAndNull(Int32 columnIndex) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetInt32(Int32 columnIndex) at MyComponent1.vbproj.Input0Buffer.get_element6type() at MyComponent1.vbproj.MapElements.selectElementId(Int32 elementType, Input0Buffer Row) at MyComponent1.vbproj.ScriptMain.SetElementDetails(Input0Buffer Row) at MyComponent1.vbproj.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) Please hellllllllllllllllllp. Thanks in advance.