Here we go.
We have several TSQL stored procedures that require input parameters. We
are using a DTS package as a driver procedure to execute this set of stored
procedures. Currently, we are using the Execute SQL Task in DTS to begin
the stored procs.....and hard coding the parameters there.....but we would
like to have one place to edit the parameters rather than 1,2,3,4,5,6,
places etc.
Is it possible to pass one or more DTS global variables to a stored
procedure (TSQL) that is being executed within that particular package? If
so how....VBscript???
thanks in advance