DSXchange

Can you please post the record schema? Does this contain {quote=single} or similar for the integer fields? If so, get into the extended properties and change to None.

Look for line terminators in the data.

I don't believe it's possible.

Create a reproducible case then report the alleged bug to IBM through your support provider.

Be systematic and painstaking. Make a checklist.

Now change output<1> to Convert(@FM,"~",output) in DSLoginfo() and show us what gets logged.

Please hurry with your response, Sudipta. This matter is urgent!!!!!

(See Maskerade by Terry Pratchett for the specific meaning of five exclamation marks.)

The main reason for the increase is the new java-based client (which requires the java-engine). Most of the IBM SE's say that the client will be ok with 2 MB, but if you typically run several other applications at the same time you might want to consider 3MB. He means GB, of course, not MB. Only Bi...

Welcome aboard. Start with a specification of what you are planning to achieve. Why was the connection lost? Is this likely to be repeated? If so you are going to need to design some restart logic. Or get "them" to put in a more reliable network. You used the term "map". Are you using server job, or...

Craig's statements and recollection are both correct.

Your logic is faulty in the TOP section, because you don't have the description from the hashed file (note, "hashed" file, not "hash" file) You need a preliminary lookup to perform the "reverse lookup" from description to code. This may need to be fuzzy and case-insensitive. Only then can you perfor...

Basically select a set of jobs (and any dependent objects such as routines, transforms, data elements, table definitions, etc.) from the old project, export them then import them into the new project. Compile everything to make sure you have not missed any dependent components. As you get time, dele...

Alas no. As with dependencies you need to keep a checklist of some kind. Best practice is always to have a promotion checklist in any case, so that everything that needs to be promoted, or checked as already existing, is. I take it the RESIZE completed satisfactorily, otherwise your post would have ...

Welcome aboard. For problem 1 looks like you're exhausting available memory. Do you monitor memory consumption, for example with Task Manager or with Performance Monitor, on the server? For problem 2 there is obviously something in that particular job that is incompatible with provider SQLOLEDB.1 - ...

Sort them by date/time modified then select the most recent.

Execute Command activity to execute something like the above command; the return value will give you the file name which you can pass to the job as a job parameter value.

In an after-job subroutine check the log for this particular warning and set the ErrorCode argument to a non-zero value.