Hi,

We are using script component in SSIS package to execute extended procedure. The connection we are using to connect the SQL Server through script component is “.Net Providers\SqlClient Data Provider”.

Script component is failing on this line of code:

Dim reader As SqlDataReader = sqlCmd.ExecuteReader()

Below is the error we are getting.

at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser****n(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.CloseInternal( Boolean closeReader)
at System.Data.SqlClient.SqlDataReader.Close()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand****nExecuteReader Tds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand****nExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand****nExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at ScriptComponent_96decf9f71024df0bc18860c81f76582.S criptMain.Input0_ProcessInputRow(Input0Buffer Row)
at ScriptComponent_96decf9f71024df0bc18860c81f76582.U serComponent.Input0_ProcessInput(Input0Buffer Buffer)
at ScriptComponent_96decf9f71024df0bc18860c81f76582.U serComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHo st.ProcessInput(Int32 inputID, PipelineBuffer buffer)

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "Script Component" (486) failed with error code 0x80131904.
The identified component returned an error from the ProcessInput method.
The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
There may be error messages posted before this with more information about the failure.

Looking at the error I could not understand that what the error exatly is.

Can any one help me on this that what could be the cause of failing the script component?



Regards
Raj