Hi

We still use SqlServer 2000 and DTSs.

My question is: Can I pass a parameter to a DTS and if yes then how ?

We would like to plan our screen like this.
The user will input a parameter on the screen/form and then the DTS will
be activated using the value inputed.

We do have how to work around it if parameters can't be passed but it
would make things a lot easier and straightforward if we could.

Thanks !

David Greenberg

On Tue, 06 Nov 2007 22:52:28 +0200, David Greenberg
<davidgr (AT) iba (DOT) org.il> wrote:

One simple solution might be to store those parameters in a separate
table. Then write code like this:
select * from tblCustomers
where CustomerID = (select CustomerID from tblParameters)

-Tom.

Thanks Tom !
That was the work around we had planned (we've actually used that method
before successfully)


Tom van Stiphout wrote: