I am trying to create a DTS package.
I use a stored procedure with 1 parameter as a data source for the Transform Data Task in such a form:
exec sp_my_stored_procedure ?
The parameter is created. I also created Global Variable to hold the value for the parameter.
Nevertheless, when I try to execute stored procedure (I push the Preview button), I get the following
Values for one or more required parameters are missed
Can anybody help me ?