DSXchange

What exactly did you have restored? Did the restore maintain the original permissions, ownerships, etc etc? Was what was there removed first or did you restore over it?

Basic Call Interface. Search for it here, there's been a ton of discussions on and examples of its syntax posted. Only "problem" might be the fact that the reigning champion on the subject is Ray.

Best place to start is here. Plus, oddly enough, the documentation that ships with the product. After that, best to ask specific questions or give us more than "not able to write it" to work with if you need more help. You could also search the forums here for "XMLInput" for othe...

To the last two posters, dates will use and "expect" the NLS_DATE_FORMAT as the default, never assume it will always be DD-MON-YYYY.

What version are you using?

I actually meant, when set to 'ODBC' it uses ODBC as the interface. :? I personally stick with OCI and don't use DRS as I abhor the "?" parameter markers it uses and don't need the "switch to any other database on the fly!" capability it was built to allow. Plus it has fewer opti...

You can't do what you are doing with HF2 without a much better understanding of the fact that hashed files are metadata driven and how the columns are positional and thus don't operate like database tables. You are going to get yourself in trouble if you make a habit of writing to one with one set o...

1) Ah, yes... SQL Server. I'm not really all that familiar with it but from what I've seen here you would have to deliver the file to the Windows server in order to bulk load it. Don't have that issue with other databases so tend to forget that little qualifier. So someone else more SQL Server savvy...

So... to clarify... while you can't stop people from trying to run jobs, you can ensure that the jobs won't run properly if they do? What does actually happen in that case, I'm assuming the job aborts before it gets very far, yes?

Seems to me a little early to be proclaiming that "DS is not accepting long names". Can you post the actual "buffer overflow error" that you are getting? Can you clarify what you mean by "long" - how long is a table name that seems to be "too long"? Anything f...

Combo actions are something I personally avoid the vast majority of the time except for very small data volumes - i.e. one row. I prefer qualifying my actions and using dedicated insert and update links. It also means that - if desired - I can land both to files, bulk load the inserts and then do th...

Glad that was it.

Neither your TO_CHAR() nor your TO_DATE() functions have the appropriate 'mask' to use for the conversion.

Hard to say, one way or the other, just from what was posted. Time will tell.

First off, how about explaining what the "problem with accessing the archived datasets" you've been having is?