DSXchange

Honestly, I don't know any other conclusion to jump to. I've never seen one 'accidently' or how did the OP put it... 'some how' try to start a job again. I don't see how that could possibly happen. Now, for a one-time non-repeatable occurance, then some other sequence or a manual process started the...

Your table must be partitioned to get it to run in something other than Sequential mode.

i think due to this type of multilanguage character im unable to load it,but if i increase the length to varchar2(100) im able to load these data and no error occurs,but i feel this should'n be the solution. To me, that's a perfectly valid solution. Is your VARCHAR2(50) field actually defined as 50...

Sounds like you should use ftp, but you should double-check that it shouldn't be a secure transfer instead. And there are a crap ton of examples out there on how to do any of that - try googling for 'ftp here document' or 'ftp script' to get started.

Work with your DBA. If the table is indeed being locked, then yes you'll have issues. Typically the locks are only record level locks so as long as there's no collisions there you should be ok.

You can also investigate the use of the Mod() function to base your link filter on.

Something else tried to start the job while it was already running. You need to find out who/what that was.

From the GUI, all you can do is move it after the import. Be careful editing the dsx, I horked up a project once with an improper category change via editing. Was a bee-yatch to fix.

There's a complete, working version of one in the DS Tips section of Kim Duke's website. You could use or at least crib from it.

You need to involve your official support provider at this point.

If I had a place to do so, I could post images of these results and it would demonstrate these results. :idea: You could upload them to any file sharing site, places like ImageShack and MediaFire (amongst others) are still free AFAIK. Then you can include a link to the images in your post and the s...

While true that statement in no way changes the correctness of what I wrote. Nor was it meant to. It was strictly in response to this: I noticed one thing while creating HASH FILE. When the job creates a new HASH FILE, it creates a folder with 2 files. I was hoping it would open up a little dialogu...

mail2hfz wrote:Yes I can view the data on Sequential file Stage.

Then there's no issue reading the file it would seem. Copy the job, pop off the Oracle stage and replace it with another Sequential File stage and see what happens then.

That's... odd. Can you View Data on the sequential file from the source stage?