I have a DTS package that exports contents of a table to a text file. I want to modify it so at execution time, it will prompt me for PLANT value and export only matching rows. I put a "WHERE PLANT = ?" in my query and setup a global variable to map to Parameter1, but how do I get it to prompt me for the value of the global variable at runtime? In Access, simply saying "WHERE PLANT = ?" will cause it to prompt for a value.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS Parameters at Runtime
- Thread starter GoHogs
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question