More than one Parameter in DTS Package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

More than one Parameter in DTS Package

Author

Topic

namasteall2000
Starting Member

20 Posts

Posted - 2006-06-13 : 11:16:53

Hi guys - I want to use more than one parameter in one of my package. It works fine till the time I have one parameter and I use "?" in my SQL.

My active X script says like this

Function Main()
Dim result
Dim Formtype
result=InputBox("Enter date")
FormType = InputBox("Enter Form Type")
DTSGlobalVariables("g_date").Value=result
DTSGlobalVariables("g_Formtype").Value=Formtype
Main = DTSTaskExecResult_Success

End Function

After this it prompts me to enter 2 parameter. But I don't know how to take these parameter to my SQL. Can anyone let me know where I am wrong? I am writing this SQL to get values at G_Date and g_Formtype -but this doesn't send any results. I know there is some problem in SQL.

Declare @G_Date as smalldatetime
Declare @G_FormType as Varchar(15)

--Set @G_date = '02-02-2006'
select top 20 claimid, startdate, enddate , Formtype
from plandata_prod..claim
where startdate < @G_Date
--and FormType = @G_Formtype

Thanks in advance...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources