Post reply

Script component fail on ExecuteReader().

  • December 17, 2009 at 7:28 am

    #136016

    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(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Run(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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader()

    at ScriptComponent_96decf9f71024df0bc18860c81f76582.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row)

    at ScriptComponent_96decf9f71024df0bc18860c81f76582.UserComponent.Input0_ProcessInput(Input0Buffer Buffer)

    at ScriptComponent_96decf9f71024df0bc18860c81f76582.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer)

    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.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

  • December 19, 2009 at 8:31 am

    #1094447

    This is the error stack dump and it is not helpful. Can you setup your code like this:

    Dim reader As SqlDataReader

    Try

    reader = sqlCmd.ExecuteReader()

    Catch ex As Exception

    Call MsgBox( ex.Message )

    End Try

    This will print the error. What is the error?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply