DSXchange

Define what 'loading' means here - all inserts? To answer the bulk load question, you'd need to actually mention the name of the database you're working with.

You need to read the help on the Folder stage so you know how it works and thus know when to use it.

A rename is basically a delete and would have the same need to 'unlink', I would look there.

What version of the Oracle client do you have installed on the new box? I'm curious if it is the same one as on the old box.

Add a specific IsNull check or perhaps try IsValid rather than Num.

The Director online help has good information on Multi-Instance options. Biggest thing is the job needs to be designed with MI support in mind, particularly how resources are shared (or not).

Sure, a flat file would be the typical approach. You would use a UserVariables stage to read them in dynamically at runtime into a delimited list to pass to the Start Loop stage.

If you want to leverage an installed client, you'd need to use a "thick" non-wired driver to do so. Use the thin driver when you do not have a client installed.

You need to start your own post on this subject, not hi-jack another thread where the only common element is the database vendor.

raghucsh wrote:I need to WRITE a Unix Shell Script.

<snip what it needs to do>

Please send the script.

Don't you see a teensy problem with this?

dsedi wrote:Can I use the DSGetLinkInfo in the Job activity Trigger expression?

In other words, nope.

Set the "Index option" it mentions in the stage to "Rebuild", that should automatically do the equivalent of what your stored procedure was doing. Or was there something special or different about what exactly the proc did?

It seems you need to ensure the value of FIELD is quoted in the select if you are going to be passing character data in to it. Of course, that all depends on what "unable to take the character value" means. As to the other problem, I don't see why you are bothering with a routine as there'...

Same facility.

few records coming from source file for this column is containing seconds >60. My business rule is i need to populate the data with seconds <60 If the records are coming with seconds >60 . Sorry but that doesn't explain anything. How do you reduce the seconds to less than 60? What is the transforma...