How do I pass a parameter to a DTS ?

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

Re: How do I pass a parameter to a DTS ?

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

Re: How do I pass a parameter to a DTS ?

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


Tom van Stiphout wrote:
> On Tue, 06 Nov 2007 22:52:28 +0200, David Greenberg
> 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
>