DSXchange

Who actually owns the RT_LOG hashed file and its components? Does it work if you log in as that user?

I got 29 matches when searching for "because of a prior component", so it's not like this question has never been asked before.

Sounds like you are passing the entire list to the Job Activity stage parameter rather than just the 'current' filename from the list based on the loop counter $Counter - see this post for one example of many here.

He did.

You'd have to tell us. Were patches applied, either to the O/S or (more probably) the DataStage product?

Pffttt... we're all always gonna be riding drag on the Ray Wurlod cattle drive.

Yes, please, let's not... I have to live with that shame every day.

But it ages rather rapidly and, like most old folks, sleeps less and less as time goes on.

Looks like ODBC is the mechanism of choice, unless they've opted for SQL Server under the covers.

http://www.easysoft.com/applications/mi ... -odbc.html

koojo wrote:What are the ETL capabilities of Navision?

Best to ask that question someplace more... Navision specific.

You don't need to. However, you should ask the source system to properly quote any string values.

I'm not sure how much stock I'd put into sites like that one. :? Best Practice is to minimize the number of DB stages and thus the number of connections consumed, something which also lets the work be done as a single transaction if desired and helps avoid most deadlock / RI issues. Much like Mike, ...

Exactly. What's the alleged curse? Ah, yes... May you live in interesting times.

Parallel Job Developer's Guide pdf, Chapter 20... or thereabouts.

Yikes! Get a life!

Now you are responding to the original poster's question rather than the 'hijack' by Suresh, which is what we are currently addressing. :idea: People, please start your own post even when it seems like you have "the same problem" as someone else. You don't, you have your own perhaps simila...