Q: With the SQL Source is there a way to access the RecordCount as variable? Would be nice to include it in the subject line of an email Destination. Many thanks!
A: We added two new parameters in version v2022.3.18.0.
- %QDC = Query Destination record Count, when using SQL as Destination
- %QSC = Query Source record Count, when using SQL as Source
You can use %QDC and %QSC within your email or at other positions where parameters can be used. Some screenshots to get you started.
1. In our example we’ll be using SQL as Source. You can find more information about the setup of ‘SQL as Source’ in our Blog.
2. We’ll be using the new %QSC parameter in an email event:
3. We enabled the ‘On Success’ event and the ‘Enable Mail’ option:
4. In the email setup we used our new %QSC parameter so the RecordCount will be displayed.
4. Received Email:
#SQL #Filetransfer
If you need any info about this ‘RecordCount as variable’ option, please let us know.
Best regards,
Limagito Team
