DSXchange

Have you configured a data source name to use the Microsoft SQL Server driver rather than the appropriate Oracle driver?

We can. Overwrite the record.

Columns that contain line terminators must be quoted, if I recall correctly.

Metadata is found in system tables. Do you have SELECT privilege to the appropriate system tables for this particular import?

Every option in Data Set Management tool uses an orchadmin command under the covers.

We need to see the configuration file that you used, in particular how many distinct fastname values occur in it. Also, do you have a firewall enabled? If so, are all the ports used by Information Server open? (There are about 20 of them.)

Mixican data, perhaps?

Tools > Data Set Management in Designer.

You can also set the Peek stage to capture only from particular nodes. (I can't recall whether the same capability is available from the data browser, though I suspect that it isn't.)

I don't believe so. The "job finished" message should be the last thing that the job does. You will need some more exact form of tracing, possibly with the aid of your official support provider, to determine what's happening between the end of one job and the start of the next. For example...

It means that there is not enough space in memory. That's the "map" part of the error message. What are the ulimit settings of the user that is executing the job?

You could always intersperse a filtering stage (Filter or Transformer) to capture these rows before they are re-parsed by the Column Import stage.

I don't know how to create a virtual table based on a join, but only because it's not something I've ever tried. I have profiled views in the past, with success. Data rules won't really help, because you still have to get data from all three source tables. Data rules can tell you how many rows compl...

Take a look at the Null Field Value property (there may not be one) and the Default Value property (which I'm guessing is set to "").

Report on job is the fourth compilation option for a sequence, to be found in its job properties. Uncheck this box and re-compile the sequence.

Why not StringToTimestamp(InLink.TheDate : " " : InLink.TheTime) ? If course your elements need to be in the appropriate ISO 8601 format for this to work.