SQL Server Performance Forum – Threads Archive
Parameterized DTS PackegesHow we can create a parameterized DTS Packages .Here i have to do this following task with DTS Package
Create procedure sreeni_mwc
Declare @initiatedate datetime
Set @initiatedate = getdate()
–Where loaddate > @initiatedate
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.
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
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