Posted by David Greenberg on 11/07/07 06:43

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

• Next in forum: Re: Aggregate Fun (Getting the Max out of MAX)...head scratcher
• Prev in forum: Re: Aggregate Fun (Getting the Max out of MAX)...head scratcher
• Thread view: Re: How do I pass a parameter to a DTS ?

[Reply to this message]