DSXchange

The subject of your Premium Membership was moved here and any further conversation on that topic needs to happen there. Let's leave this one for your External Source performance topic.

pavan5035 wrote:DSXchange User Name: pavi

That email says it is for a different user name and if I search for all posts by "pavi" they do come up as a Premium Member.

ps. Removing the personal information from your post...

Ernie, question for you - should this discussion be over in the SOA/RTI forum? Happy to move it if that's the case.

Emphasis mine:

eostic wrote:There are far too many variables.

If there was anything that I wanted to add to my previous post, this was it. And Ernie's full post details it nicely.

Well... that is where it all starts.

Nothing in the documentation shows a need for quotes. And the suggestion was to leave the Skip option unset as you are not skipping sheets within the range you are specifying.

Test results are contradicting to general hard and fast rule that writing to a file and reading from a file is a costly operation than reading directly from STDOUT. It's an interesting discussion and test but to be honest I've never heard of this "general hard and fast rule". For whatever...

ankursaxena.2003 wrote:It is tough to put down the requirement in words.

I would imagine, though, that someone gave you the task and requirements in words did they not?

Wait... what? That wasn't directed at you but to everyone else. Or are you saying you are having a problem running the job? I thought the job was running fine, you just didn't think you were getting the proper status return code.

Isn't there still a "Job Report" that you can generate from the Designer via a button? Not anything to do with operational metadata, but simply an HTML report of the contents of the job (transforms and all) all nicely hot-linked.

Make sure you catch this point before responding (emphasis mine):

SURA wrote:I don't have problem to run a job! This is about to get the status of the job.

I was wondering how they came up with that particular value...

Interesting... thanks for posting your resolution.

<split out from this topic>

Your own questions go into your own posts.

Yah, that seems like the only possibly viable approach. Meaning you export the entire project and then make passes through the export doing pattern matching / updating strings for all of the names you noted. Then re-import the edited export and cross your fingers. Or better yet import into a new pro...