SQL Server Integration Services - How to use Stored Procedure in OLE DB Source in SSIS Package

[@krismaly6300]

I enjoyed watching this video and recommend others.
It has been clearly explained how to use procedure with a parameter in a package with example. Also How to set Input or Out parameter and how to pass a parameter value using Variable..
Thanks for educating the community and appreciate your volunteership.
Thanks a lot

[@InLiveLife]

Brillaint, thank you so much. Relatively easy task, but not for beginners like me haha

[@krismaly6300]

I enjoyed watching this video and recommend others.
It has been clearly explained how to use procedure with a parameter in a package with example. Also How to set Input or Out parameter and how to pass a parameter value using Variable..
Thanks for educating the community and appreciate your voluntee-rship.
Thanks a lot

[@MrDavisv]

Great explanation! Thank you, this is going to help me a lot.

[@OguzhanlaAlmanya]

can we sent the data of a column as parameter to this procedure/function ?

[@sathiyamoorthi9224]

All your videos are Awesome .i have different directory including that multiple excel sheet. How load into sql table can you please help or provide video's

[@kilojeet123]

Awesome tutorials Aamir. Thanks!!

[@TechBrothersIT]

Karanjeet Singh You are welcome Karanjeet Singh!

[@Skd833]

While calling a stored procedure in OLEDB Command, I am getting PLS-00703: Multiple instances of named argument in listora 06550...error..Please any 1 help me out on this...Just for info-the Stored procedure individually is successfully executed

[@sagittariusguy2011]

you never told the variable which you made before starting the video "RegionCode" then you again created a new variable "RegionCode1" and then you again selected "RegionCode" , I am confused which one of the code did u use ?

[@balakk5009]

i am not getting result , but pkg is executed successfully.

[@gauravolap]

good

[@TechBrothersIT]

Gaurav Shri Thanks!