DSXchange

Why is this marked as a WORKAROUND?

As noted, they are completely different things and the difference has been explained. Twice.

Give us an example of what you're getting and what you want to turn it into. Also be curious why you don't want the seconds.

Easy - don't use a semi-colon. No need for them in your SQL.

Error in binding: Expected source field selector or conversion name

It is expecting a column to modify, that or drop columns from the link - but you can't use a Modify stage to create new columns.

It means just what it says - a job must have been compiled and not be running in order to be started. You usually get that error when the job is already running, or if it is in an Aborted state and you haven't used 'Reset if required then run'.

Did you try... oh, I don't know... searching?

I got several hits on "Null value on the accessor interfacing to field" when I did.

I think that's mentioned in pretty much every post I linked.

Actually it is through various means and it has been discussed here a number of times. A quick search found several topics, I know there are plenty more out there. m m m m m m Note these are general 'how do I find' posts, not necessarily exact answers to the poster's question. They should get them s...

As Arnd has already noted - no, there is no such 'inbuilt feature' available so no need to keep asking. Unless you code something else, they start from the beginning each time unless you use the checkpointing option and jobs are aborted. If you needed variable start points in your Sequence jobs, tha...

If that works for you, then it's just as 'right' as any other way.

Wow... you guys are way too anal. Did you not notice Mr Winkie? You know, as in 'wink, wink, nudge, nudge'.

I'm sure you'll need to take the extra step to remove any 'Field Marks' from the output. So, either an ERplace or Convert to strip them before the check or...

Best place to start would be the RTI pdf documents included with the product. There is both a User Guide and an Admin Guide for your reading pleasure.

Whizdee... that's what I couldn't remember.

Well, if you have those two stages then you have RTI. No-one is going to be able to explain everything about RTI in a post here, you'd really need to attend a class. That or bring in an experienced consultant to get you started.