I want to pass two parameters into a custom SQL source query. How do I do that ?
I tried same in my case but scribe not prompting to take user value. It is taking default one. Below steps i have done, not sure where i am going wrong or its just scribe defect?
1- Created Prompted variable called In_Starttime (image attached)
2- Passes this variable to source query.
3- When running scribe job taking default value provided while creating variable.
If you are using Insight, a prompted variable is the direction to go. Here's a link to the help on that.
When opening the DTS file, prompted variables will ask the user for input. You can also pass a value to a prompted variable using the command line switches for tworkbench.exe. In that case there is no prompt.
If you are using Scribe Online, there is not a way to pass parameters to the source query.