Sunday, 21 October 2018

IsQueryStoredProcedure property in Execute SQL Task in SSIS

This property is available on ADO.NET and ADO connection type in execute SQL task.
       
     
By default value of this property is False.
If we select other than ADO.NET and ADO then, in this case, this property will be disabled.
      
   
It confirms, the specified SQL statement is stored procedure or not. This property is editable only if the specified connection is ADO or ADO.NET, otherwise, the property is disabled only and the default value will be, “False”.

Connection type
IsQueryStoredProcedure
SQL Statement
ADO
FALSE
EXEC SP_NAME?,?(parameter)
ADO
TRUE
SP_NAME ?,?
ADO.NET
FALSE
EXEC SP_NAME @Param1,@param2
ADO.NET
TRUE
Procudername @param1,@param2

1 comment:

  1. How to make money from betting on football - Work Tomake Money
    If you're having problems finding 메이저 카지노 사이트 a winning bet online for the day of your choosing, 카지노 then nov카지노 사이트 there 골드 카지노 are plenty of opportunities available right หาเงินออนไลน์ here.

    ReplyDelete

If you have any doubt, please let me know.

Popular Posts