Very Computer

by **Garret** » Sat, 08 Sep 2001 01:13:18

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

by **Euan Garde** » Sat, 08 Sep 2001 15:11:34

You can do it by using VBScript to re-write the SQL statement from an Ax
Script task that executes before the ExecSQL, or in SQL 2000 you can do it
via Parameters. If you use parameters try using the SQL Server OLE DB
Providers and also the SQL ODBC driver via the OLE DB Provider for ODBC.
Parameterised SP's are VERY sensitive to driver meta data.

--
Euan

Please respond directly to the newsgroup and not via e-mail.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

Quote:> 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

Very Computer

Passing DTS Global Variables to Stored Procedures

Passing DTS Global Variables to Stored Procedures

Passing DTS Global Variables to Stored Procedures