DSXchange

You would use IConv and do the date and time portions separately - 'D' for data and 'MT' for time.

Perhaps this (rather long) thread might have the info you are looking for?

http://www.dsxchange.com/viewtopic.php?t=115619

As long as you have 32-bit drivers/client you should be fine.

Ugh. Why do all that when a simple job with an OCI or ODBC stage will easily do the same thing?

Me, for that many tables I would just script this and then execute the script via sqlplus.

Pivot stage.

'Tyros'? Good lord Ray, Medieval Latin? Why not just say 'beginner' or 'noob'?

Try resetting the aborted job from the Director and let us know the contents of any 'From previous run...' log message that (hopefully) shows up.

"My job is stored in a FTP server say X.How to find the path of that particular job stored in FTP server?" You really aren't making a whole lot of sense. Jobs are not 'stored in an FTP server'. Let's step back and start over again. Perhaps you could explain exactly what in the heck you are trying t...

Yes indeed, it's a bug. If this does indeed fix your issue, please come back and mark the post as 'Resolved'. :D

For start time, you'll either need to have your scheduler wait until the proper time to start or build a 'sleep until' routine that takes an argument time and based on the current time, sleeps the 'delta seconds' until then. Then enter the loop. Inside the loop, you'll need another routine to check ...

You misunderstood. After the job aborts, reset it and then tell us the contents of the 'From previous run...' log message that should show up.

I need to call a few Oracle commands one time for a multi-instance job, I created a simple job which consist of an oracle stage and dummy file, and I put my commands in the oracle stage, now I need to call this job after a job which is multi-instance. How about you let us know what kind of 'few Ora...

You'd need to purchase and leverage UNIX drivers that can read Excel files. For example, an 'adapter' from someone like iWay Software. Otherwise you'll need to export the data, do a 'save as' in a sequential file format like the .txt or .cvs formats, which can be easily processed.

:D Yah, sometimes it just happens Ernie. You can however, before anyone replies to it, start at the bottom and delete the duplicates until only one is left. We are looking at doing this manually, actually I think the person tasked with this may have already got this worked out. I was mostly wonderin...

Not sure, as any time I've ever checked it says 'Running'. However, we don't have EE so don't know how that might affect it and we've got some 'always on' jobs as well. Found these two in my last check, made me laugh with the exclamation points: 18 printer segments abandoned! 16 phantom printer segm...