DSXchange

I too don't think there's an option for this. Curiously, when I ran strings over dsexport.exe, there was nothing output. Nothing.

And make sure that DSHOME has been set before you start using it in other environment variable definitions.

It is not legitimate to want to insert a string into an integer column. Why do you want to do this? What integer would you hope to get?

When I was learning operating system (PRIMOS) tuning in nineteen mumble mumble I was told that the optimum point is "just before the machine starts thrashing". That, of course, is a movable target, but the method was usually ramp up the parameter in question untill thrashing began, then back off a b...

Umm... last time I looked Santiago was nowhere near Stockholm. That must be pretty amazing beer you have!

There is no way to "test" the prompt text. All the prompt text is is the text that is displayed should the parameter be prompted for in the Job Run Options dialog. It allows the prompt to be in the local language (the job parameter name itself has to be in ASCII, since it effectively becomes a varia...

I say stick to import. That way the table definition is untouched by human hands and least likely to contain errors.

You are, of course permitted - nay, encouraged - to type in column descriptions where these are absent.

... and in the case of sequential file output, preserving the same transformations so that the test is fair?

Create a text file on the server that is fixed width format. Import its table definition, specifying that it is fixed width, and therefore you need to supply a comma-separated list of field widths. On the Format tab of a sequential file slage click Load and load that table definition. On the Columns...

That is, include a job parameter reference as the schema name in the Table Name field. Make sure there is a job parameter of that name.

You have two output links, one the the table, the other to the collector. The second has no constraint expression at all, since all rows are sent to the collector. The first has a constraint expression that tests whether a job parameter has the value "Y". Build this constraint expression with the ex...

Pre-process your new data through a Sort stage, getting it to add a key change column. Then process the data as if there were no duplicates through the Compare stage - I assume you're using a Compare stage - with the key change column NOT being a change column. Then, you need to filter the output bo...

Typically fixed width data files do not include quote characters; if you want these you will need to transform your data so that they have quotes - since reading quoted delimited fields from source will strip the quotes. The transformation will need to be such as to pad the string and then surround ...

MPP is automatically excluded since these are stages in server jobs, which can only ever run on one machine. SMP is not necessary either, because server jobs can run on uniprocessor systems.

<stings.h> ought not to be found. Try <string.h> or <strings.h> (depending on your actual header file name). Compiler options are required to tell the compiler where the header files are.