I had the SP,

I want to call in Script Task , had the Result set data value then I need pop up message box

So how can I call stored procedure result in message box in ssis script task using C#.

and I want  to use SSIS -OLEDB connection

So can u advice the code:

 

  ConnectionManager cm;
            System.Data.SqlClient.SqlConnection sqlConn;
            System.Data.SqlClient.SqlCommand sqlComm;
            cm = Dts.Connections["OLE_TEST_"];
            sqlConn = (System.Data.SqlClient.SqlConnection)cm.AcquireConnection(Dts.Transaction);
            sqlComm = new System.Data.SqlClient.SqlCommand("Exec dbo.sOp_xx_XXXe_VXX 280", sqlConn);
            sqlComm.ExecuteNonQuery();

above code , no message box, please advice on above without error with Message box

Thanks

• Edited by Sign of Shine 12 minutes ago edit