... which will be specific to your business requirements.
Why?
If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few ...
What?
Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...
... pretend the info we want is rather simple:
SELECT
[sequenceID],
[student_reference],
[student_title_code],
[student_name],
[student_gender_code],
...
... the examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause:
- ...
... Being rather pernickety, I would like a question mark to display if there is no date to populate the field.
Why?
At the moment, the expression in there is something like this:
=Format(Fields!MyCompletionTime.Value, ...
... in a database and rather than a separate file, it stores these in a row.
How?
Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS":
123456 ...
Applies to:
Joomla CMS v2.5.11 (Joomla.org)
jComments v2.3.0 (JoomlaTune.com)
What?
Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. ...
... (do they ever?).
The script must be able to be copied into other SSIS packages.
Need the option to merely tick input column names rather than hardcode these.
"It " should be an acronym for IT, so "I ...
... trust these more than my all-in-one GUI applications.
How?
Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one:
-- ...
... chars rather than Null).
My example here is that the first column is our employee number and the second column will be the remaining data on that row.
So I setup my connection manager as follows ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.