stored procedures - Execute SQL Task in TSQL -
i have multiple sql tasks execute stored procedures. intend call
these sql tasks
in other stored procedure. how do ?
in these sql tasks, have exec sp
statement.all these sql tasks need start in stored procedure only.
you can't call individual ssis tasks, can call ssis package stored procedure. procedure not totally straight-forwards , won't put instructions here, there many sites so.
however, if these tasks call sp, why not call sp?
Comments
Post a Comment