SSIS "Execute SQL Task" - stored procedure with input parameters

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 พ.ย. 2024

ความคิดเห็น • 6

  • @krismaly6300
    @krismaly6300 8 ปีที่แล้ว

    Awesome
    I enjoyed watching this video.
    Host seem to be a very good teacher, I like it hope other wil like.
    Covered Writing SQL Procedure with parameters and explaining Error handling before after MSSQL2012
    Explained how to use ADO.NET and OLEDB connection it was very clear
    How to create variables was very simple. Also explaining Variable usage in ADO and OLEDB was good.
    Narrator voice is very good and crisp and clear
    I love to watch his other videos.
    Suggest
    Error handling was good.
    If you could have explained writing the error to a file would make more sense and useful for developers especially new.
    Thanks for educating the community and appreciate your volunteership.
    Thanks a bunch

    • @stedenvideos3825
      @stedenvideos3825  8 ปีที่แล้ว

      Thanks for the feedback. I'm glad you got something out of it.

    • @stedenvideos3825
      @stedenvideos3825  8 ปีที่แล้ว

      +Kris Maly
      Thanks for the feedback. Glad you got something out of it.

  • @juanacevedo7357
    @juanacevedo7357 2 ปีที่แล้ว +1

    Great !!

  • @anushak2
    @anushak2 7 ปีที่แล้ว

    Is this process similar to an ODBC connection? If i'm passing multiple input parameters, would my SQL statement just be "{call GetStoredProc( @ExampleID = ?, @Name= ?)}
    P.S. I read up already on how this process would be done on the internet, but it's still a little fuzzy in my mind. Thank you for putting this up though.

  • @krismaly1231
    @krismaly1231 8 ปีที่แล้ว

    I wish you could have added Date parameter since int date and nvarchar most commonly used
    question
    in the Result Set there is Result Name is it similar to parameter orders?