DSXchange

It means nothing would ever leave the transformer down that link. You could also write the file to "/dev/null".

I don't see why not. Have you tried it? What issues have you seen?

If you are asking if the Schema File property in the Sequence File stage can be parameterized, the answer is yes.

Not as far as I know. You'd need to look up the current name (with a wildcard 'dir' perhaps) and then open it directly once you know the name.

Some would suggest the Print to file option in the Director. If you mean in an automated fashion, search here for ETLStats for many conversions on the topic.

Another way of doing what? What makes you (or them) think you need to lock the table while you're selecting from it?

I don't think that is a good idea, but ask your DBA for the syntax and then try putting it in the OPEN COMMAND section of the OE stage, assuming that's what you're using.

'Separate rows' isn't very precise. So from your example it would be 8 rows of a single column, or 4 rows with two columns?

ODBC doesn't support them, from what I recall. For Access you'd need to put square brackets around them, perhaps the same would work here?

Those are core dumps from failed processes.

Can you post an example, please? In earlier versions, you got a simple status from any successful jobs but the last entry was always the failure point and included something from the job's log from what I recall. :? If that truly does not work for you, you'll not be able to use the stage but will in...

As noted, that's all in the hands on the database and attending DBA.

Agreed but I would leave it in, just make sure it's set to False. We typically include the 'dump score' one and another I can't think of at the moment, so they can be 'activated' when needed. The generic answer to the parameter question is (in my mind) anything that could change from environment to ...

We're already well on our way, so if you want to play that card it's better to ask the Moderator to move it instead.

Moderator, please move to the Server forum.

(he really likes red)

You'd have to expand a teensy bit on what "could not load" means before anyone could do anything but guess.