DSXchange

The best stage to use to drop columns is the Copy stage, as its processing overheads are zero. The "transfer" is done by pointing the output column to the same address as the input column.

It's got nothing whatsoever to do with the tool, and everything to do with data warehouse/data mart design. A factless fact table records that something has occurred, but about which there is nothing to measure. If you search DSXchange for your term you will find some examples. You can also search o...

Can you connect to the Information Server Administration console? (Point your Internet Explorer browser at port 9080 on the machine that hosts Information Server and log in with someone with IS admin privileges. This is the only way you could correct "screwed up" permissions and/or credentials.)

In server jobs there are no data types, so you can treat both as strings and simply use substrings and concatenation. InLink.TheString[1,4] : "-" : InLink.TheString[5,2] : "-" : InLink.TheString[7,2] Or you could use Fmt() function, or a combination of Oconv() and Iconv(). Fmt...

Server jobs have a much smaller footprint and rather lower overheads, particularly for startup.

... that's just me. Control freak. Must retain control under all circumstances. It's not necessarily a best practice, but I've been around since before version 1.0, when there was no such thing as automatic reset or recovery from aborted jobs. And I just don't think it's the cleanest way to code, i...

Yes, but the terminators within an object descriptor need to be UNIX-style.

Welcome aboard. :D

Hijacking threads with unrelated questions is frowned upon here.

Can you please post your question as a new thread?

This will assist future searchers.

There you go. I have a philosophical objection to writing jobs to abort.

But that's just me. Control freak. Must retain control under all circumstances.

\(A) is a really old-fashioned way to represent 0x0a (Char(10), or LF).

One thing that can trigger it is having the "7-bit encoding" option selected. Another is doing the export from a Windows based server.

You should be safe to convert, provided you use UNIX-style line termination.

Please provide the full detail of event #198. This will include mention of the stage/operator that generated the message.

You could be looking for the problem in the wrong place.

Could it be that there are some non-printable characters in your data?

In between your two Job activities place a Routine activity that interrogates Job1 for its row count. A trigger based on the routine's return value can determine whether to execute Job2. If this trigger does not fire, then Job2 does not get executed and the sequence completes.

Can you please search for postings related to storing the previous row's value(s) in stage variable(s)? You will find your answers already waiting there.

And your proof of this assertion is ... ?

How much better? What does "better" mean in this context anyway?

How big is "large"? How big is "smaller"?