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.
| Author |
Topic |
|
raj4582
Starting Member
16 Posts |
 Posted - 2009-12-17 : 09:29:59
|
| 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?RegardsRaj |
|
|
|
|
|
|
|
Script component fail on ExecuteReader().