DSXchange

Just for the record, that will get you the current system date/time as each record is inserted. Which means it will constantly change over the course of your 'load'. And it requires user-defined sql. I prefer to have the timestamp be a constant over the course of a run so that all rows have an ident...

I've seen it, too - in 14 different posts here. Search is your friend!

I have tried a lot of time..... Hmm... I think there is a Dilbert cartoon about trying something over and over, expecting it to eventually work the way to want it to. Have you thought about the other suggestions made in this thread? Making the jobs read only or making the project a Protected projec...

And the problem is you don't get a clue from Oracle which field is the problem... you get to figure that out all on your lonesome.

Yah - pot, kettle, black.

Actually, you can easily help yourself.

Search the forum for that phrase, it has been discussed many times here.

The proper name is the 'Reporting Assistant' and it is an optional component when installing the Client on your pc. I don't bother any more.

Manager / Tools / Reporting Assistant...

As far as I know, the 'Doco Tool' can only be updated manually.

No, I understood just fine. What I don't understand is the confusion over 'transferring' files. Again, if you needed to copy a file from the one machine to another, how would you do it? That's what you would do here - no magic, no special stage involved, just a simple file transfer: ftp, scp, whatev...

What did you find when you searched the forum for a portion of that error message - like 'General repository interface'? What I found was your previous post on the same subject from earlier in the year. Did nothing ever come of that? Or did it just not raise its ugly head again until now? Did none o...

How do you transfer files? Seriously? How would you do it if you didn't have DataStage? There's your answer. Sorry, I didn't realize my posts were so confusing. Ok... let's see... Ken stated that files to be DIRECT path bulk loaded must be on the same server that the database lives on. I disagreed. ...

Why are you getting such hideous files. XML shouldn't be that big. I had the same first thought. There's no reason to be delivering files that big... if someone dropped something like that on my doorstep, I'd push back and insist they chunk it up into more digestable pieces. As in smaller pieces. H...

No, that makes you the 10.

Interesting how many times this 'problem' comes up. Someone ask the same question yesterday, I do believe, and got a very cogent answer (as always) from Ray and Ken on the subject. I'll see if I can find it and link back to it. Here it is. Sequential files are 'many readers, one writer' structures. ...

This dat file is nothing but the sequential file(correct me if i am wrong). It is *a* sequential file - fully transformed and load ready. Then you transferred this dat file to Oracle server. Can you Please explain this part. And after transferring, you Called SqlLdr which uses the created control f...