DSXchange

A User Variables activity derivation can not access other variables in the same User Variables activity. I don't like it either (or the need to add a row to the grid manually) but that's how things are. You need a second, downstream, User Variables activity that can use the variables from the first.

What error?

Please help us to help you.

DSLink9.ID, DSLInk9.WORD and DSLink9.SERVER are not variables. They are references to columns on input link DSLink9.

Hey Bob. You also need to provide the ASCII value as a three digit decimal number. Craig implied this but did not state it explicitly.

Don't convert from an unbounded string to a bounded string or from a larger string to a smaller string without an appropriate function and without a Modify stage additional Specification of NOWARN.

Do you know how to identify "active connections"? That would be a mandatory first step - I should have thought - before even thinking about killing them. The best way, of course, is to contact the owners of those sessions and ask them to close them. The next best way is to identify the client connec...

How many SCD stages? You can always make the final stage (the fact table) a sequential file stage, and bulk load (the inserts) into SQL Server.

As many as don't decrease whatever it is you mean by "performance". As to the actual number, it depends on a number of variables, each case must be addressed on its merits. My preferred answer is "one", because that's the easiest number of links to maintain, a key tenet of developer performance.

The same number as in the other place you asked this question today.

Posting the same question multiple times wastes our time, and gives us a negative attitude towards being willing to help.

No, because there are too many variables, such as row size and number of rows in each reference set and what you are using to provide rows to the reference links.

Odd. I've been able to load Oracle table using Load mode.

No. never encountered this.

Can you please post a complete and exact error message (copy/paste)?

In your ETL stream you have identified the rows that need to be inserted. Use Upsert with "Insert, then Update".
To make doubly sure, add a "false" constraint to the UPDATE statement, for example WHERE 1 = 0.

There are only five premium posters, one of whom is currently sailing (or riding out storms) in the Caribbean. Anyone else with constructive thoughts on any issue is welcome to post, but it's their choice whether they do or not.

Anyway, don't you have an official support provider?

The same way you can using sqlldr in isolation. It is simply not possible.
This is not a DataStage restriction.