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

Demonstration of how to call a stored procedure to update a table with input parameters from a SSIS Execute SQL Task. Covers error handling of update failures. Examples cover OLE DB and ADO.NET.

[krismaly]

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

[anushak]

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.

[krismaly]

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?