Steps:
- Define where the SQL results will be written
- Make sure the file does not already exist
- SQL task to get the result
- Load the file back into a property
Use the propertyregex task to strip out just the unique number
Warning: The syntax highlighter appears to be reformatting my XML and not allowing the self closing tags. Probably my problem but you should be able to get the idea from the
SELECT PREF_VALUE FROM PREFERENCE WHERE PREFERENCE_ID = 71;
No comments:
Post a Comment