DSXchange

Should IS (line #2) be AS ?

Print out your code and "bench test" it. Using a pencil trace your way through the various pieces of logic in the code for particular values of the variables. Make sure also that every path through the logic assignes a value to the variable called VAL.

You have a field called C on the output link of your Transformer stage. What it the derivation expression for this?

Display of link row counts in Designer is only cosmetic anyway. The rows are still processed and the row counts collected (and reported in log and monitor views in Director).

Job sequence with a list of the range pairs.

Job names not only must be spelled correctly, they must also be cased correctly.

Can you write to a text file, rather than to SQL Server, and at least isolate the hang behaviour to source or target? Then, maybe, a job to read that text file and insert into SQL Server, to eliminate interaction between the databases as a cause? Is there anything that might be locking a row or tabl...

This is the third time you've asked this SQLConnect question.

Are you using version 8, or an earlier version?

mohandl wrote:Hi All

Is there any way to compare two .dsx files having same code but diff environments.

Mohan

Once you get version 8, you can compare two versions of, say, a job right there on the canvas, and the report contains hyperlinks to the location of all differences found. Magic!

Any UTF is an encoding of Unicode which is an international convention for encoding every character that might be encountered anywhere in commercial data processing. Including Chinese characters, both simplified and traditional.

What you posted here consists of five informational messages. Was there any more?

SQLConnect is the ODBC API function that connects to a data source. There is usually more useful information than that. Have you posted all the error/warning information that was logged? In the Administrator client's command window, try using the test utility called DS_CONNECT to see whether you can...

There are many versions of the ODBC standard. It is a Microsoft standard. The ODBC Enterprise stage documentation (in the Parallel Job Developer's Guide) suggests that it is compliant with version 3.5 of the ODBC standard - read the manual for more detailed information about the grammar and API.

Other way around. Change 1252 in the header to 874, as I outlined elsewhere.