Posted by Tom van Stiphout on 11/07/07 03:02

On Tue, 06 Nov 2007 22:52:28 +0200, David Greenberg
<davidgr@iba.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.


>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

[Back to original message]