SQL Server Performance Forum – Threads Archive
Parameterized DTS Packeges
How we can create a parameterized DTS Packages .Here i have to do this following task with DTS PackageCreate procedure sreeni_mwc
As
Declare @initiatedate datetime
Set @initiatedate = getdate()
–Where loaddate > @initiatedate
Select statement
From tablename
WHERE (loaddate> @initiatedate) (THIS LOADDATE ALWAYS FEED EXTERNALLY)
this above procedure run through DTS or select statement with where clause should be declared variable run through DTS.
Main idea is when push execute package should me the parameter.
SRJ2005
Hi Reethu, You need to create a Global Parameter. http://www.devguru.com/features/tutorials/DTS/DTS3.asp
shows how to create parameter. Waqar ________________________________________________
~* Opinions are like a$$holes, everyone got one. *~
http://www.sqldts.com is also a good resource for such code examples. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
THANK YOU It is very helpful, and worked for my needs. SRJ2005
i tried to create Global variables as input and output
i created this way
input parametre name where cluase columnname datatype string parametre ?
output parametre name result string notdefined
when i excuted it is not prompting to parametre it just extracting all where cluase columns records, in this am i doing any thing wrong? in passing parametres SRJ2005
]]>