Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Error while execute sql task in SSIS running MySQL stored procedure?

Answered Error while execute sql task in SSIS running MySQL stored procedure?

  • Sunday, March 17, 2013 6:05 AM
     
      Has Code
    Sign In to Vote
    0

    Here is the error it is showing when executed.

    Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "CALL Fact_Temp_Initial_Load()" failed with the following error: "Procedure or function '`CALL Fact_Temp_Initial_Load()`' cannot be found in database '`panelint`'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task

    I just want to run the Stored Procedure in MySQL. I don't have any resultset or any output of that particular stored procedure.

    Any idea how to deal with this error?

     

All Replies

  • Sunday, March 17, 2013 12:20 PM
     
     
    Sign In to Vote
    0
    Any Idea on how to do this?
     
  • Sunday, March 17, 2013 1:19 PM
     
     
    Sign In to Vote
    0
    Anyone Please suggest something on this? I couldn't get breakthrough on this.
     
  • Sunday, March 17, 2013 2:35 PM
     
     
    Sign In to Vote
    0
    Is this procedure available in the MySQL database? 

    Nitesh Rai- Please mark the post as answered if it answers your question

     
  • Monday, March 18, 2013 3:36 AM
     
     
    Sign In to Vote
    0
    Yes It Is.
     
  • Monday, March 18, 2013 3:37 AM
     
     
    Sign In to Vote
    0
    But It will take quite sometime to execute it. Maybe 1 Hr for initial load.
     
  • Wednesday, March 20, 2013 6:14 AM
     
     Answered
    Sign In to Vote
    0
    Actually it always runs the procedure but fails the execute sql task. So I created the flow event it fails the next item should execute. I don't see any other way to get the task as sucess after executing the stored procedure in MySQL.
    • Marked As Answer by webdev1986 Wednesday, March 20, 2013 6:14 AM
    •