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

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

Steden Videos

9 лет назад

21,792 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Juan Acevedo
Juan Acevedo - 28.03.2022 11:39

Great !!

Ответить
anushak2
anushak2 - 31.08.2017 03:27

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
krismaly - 22.02.2016 05:53

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?

Ответить