Say you have a procedure like this on your MSSQL db which you want to call from SSIS. It has an input and output parameter which we want to use:
In SSIS we make two variables:
Add an Execute SQL task to your Sequence Container
In the properties set the name, description and connection.
For the SQLstatement put:
At the parameter mapping set direction and Parameter Name. The Parameter Name should a sequence starting at 0. The sequence should correpond with the order of the question marks in in your SQL statement.
Run your package (F5) to see if it works
Till Next Time
In SSIS we make two variables:
Add an Execute SQL task to your Sequence Container
In the properties set the name, description and connection.
For the SQLstatement put:
At the parameter mapping set direction and Parameter Name. The Parameter Name should a sequence starting at 0. The sequence should correpond with the order of the question marks in in your SQL statement.
Run your package (F5) to see if it works
Till Next Time
Posts
1 comment:
Slots at Foxwoods Casino, Mashantucket, CT - Mapyro
Foxwoods Casino Resort is a casino and hotel located in 상주 출장마사지 Mashantucket, Connecticut. 통영 출장안마 The casino is 공주 출장안마 a resort in 하남 출장마사지 Mashantucket, 파주 출장샵
Post a Comment