DSXchange

Thankfully, no you do not mon ami.

And the "back quote" that Andy mentions is officially called a grave accent.

I tried to do the same but if I have to dump that small portion of data, I need to create a separate job for it. So? You'd just need to run it first. You haven't clarified for us how much data is "left" after the delete (or if you could get the grants to do that) to help decide if the app...

... and if it still works like it has before this, an XML export is first converted back to dsx format 'under the covers' and then imported. Another part of the slowing down of the process.

If the amount of data you are keeping is a very small portion of the data to be deleted, you may want to look into the old trick of creating a new table with just the data to keep copied into it and then drop and swap.

I think a full re-install is in your future but I'll let others who know for certain reply. However, I did just have to say...

synsog wrote:but since the C drive is not backed up on the server

Seriously?

Did you try an exact search here for "sharepoint"? It returned 15 other posts for me when I did...

Well... you're not deleting just the "previous day's data" with that statement, you are deleting ALL dates less than the business date. Are those two equivalent? Is everything less than the business date all from the previous day? ps. Creating another job won't change how a 30M record tran...

I meant only to give a generic idea that I'm using a SUBSTR. Just an FYI but that's never a good idea. When people post "generic" examples or "something like" whatever it is that they are actually doing we can spend time chasing our tails until what they are actually doing is cl...

The connectors are fully documented. As noted in the Connectivity Guide for Oracle Databases pdf: 1. From the parallel canvas, double-click the Oracle connector icon, and then select the output link to edit 2. Set Read mode to Select 3. Set Generate SQL at runtime to No, and then specify the SELECT ...

FWIW, we use '12/31/9999' as one of our magic dates.

You strip out the so-called "unreadable" characters? Throw away the client's data? That would be a big no-no here. Are you sure you don't want to fix this instead?

OK.

The Reply to topic link is at the top and bottom of every page. When you are reading this look down a little bit.

And that's why I said to increase it to something larger like 100 and see what ends up in the field.

Thank you. Just really wanted to note that it's not really necessary to do that, we're here several times a day every day and really try to keep an eye on things as much as possible. :wink: A couple of other thoughts... there is a Reply to topic link, there's no need to 'Reply with quote' each and e...