DSXchange

Of course but I was specifically responding to their "server or project level setting" question.

"DB Call Failure(success check) Info = 0, Code = 3695, Message = A Single AMP Select statement has been issued in FastExport"

Why not address the error the job reported?

sagar deshmukh wrote:Any can help?

All you've said so far is "it is failing" or "it failed"... why not post the error message(s) so we have some dang idea why it is failing?

Since the SQL is apparently valid, have you checked with your official support provider? Perhaps it is a known issue...

What have you tried? What are your thoughts on this matter?

Please put a little more thought into your Subjects, I've corrected them so far but don't want to turn that into a career.

The only 'setting' that does something like this is to protect the project, but that's not the issue here. There's more than 1 DSJOB_OBJECTS records to update, join to DS_JOBS by id and filter on the job's name there.

sri75 wrote:can we do this usiing aggregate stage instead of stage variables.

Yes, take the max of each column.

Corrected.

So, your target is another file?

It does not but at least there you have the Row Generator stage.

How did you create your XPath Expressions?

behrouz wrote:i am trying to read this xml from xml output but get some strange error

Do we have to guess the "strange error" you are getting?

Every version comes with an 'Installation and Upgrade Guide' that lays out the whole process. At a very high level, you'll need to export all projects from the old 7.x environment and import them into the new 8.x environment, which will compile them as well so no need to do that manually. Should you...

Well... there's always Google. And Wikipedia.

http://en.wikipedia.org/wiki/Pluggable_ ... on_Modules

Many many severals.

No need to hope, they're all out there for the googling. For example, here. You also need to realize that a zero return code does not always mean everything is OK.