DSXchange

You can't execute 'a file' in Before/After SQL... only sql.

Come on... I didn't say for you to slavish do exactly what he said but to follow his advice. Beside, that was before you showed that your file was not in the same directory being deleted, which was the assumption under which the previous advice was given. Use some common sense. Some questions: Is #D...

Harken back to the advice given to you by Narasimha. Use two parameters. Seeing as your file is apparently *not* in the directory to be deleted, one will hold the directory and one for the file itself.

Easy Peasy.

The test failed, so no further steps were run. Is this really the full path to your status file?

/home/edw/deletestatus/home/edw/delstatus.txt

I don't think so.

Mark this thread as Resolved and start a new thread, please.

Define 'performance problem'. How many records are in the target table? How long does it take to process your 47 records? And I assume you are using the Oracle Enterprise stage, yes?

[cheech] U's not here man... [/chong] No, I simply answered the original quoted question. Are you doing something wrong? No. Ten jobs to process ten different files is perfectly fine. Just how 'different' are these different file layouts? If the differences are fairly minor, then perhaps you can cut...

dsdeveloper123 wrote:I am new to data stage so was wondering if what I am doing is right or wrong...

It's perfectly fine... aka 'right'.

Search the site for "because of a prior component with the same name".

So, just send a short email to their cell phone 'email address'. For example, I send messages to my Sprint phone using '##########@messaging.sprintpcs.com' as the 'send to' address where the #s are the 10 digit phone number. No template tweaking or change of any kind needed. All carriers seem to hav...

You really should have seen that one coming, Arnd.

Nothing will appear in any dropdown until you actually import something and the value is in the repository. To start things off, you should just be able to type the value in rather than pick it from a list. From what I recall.

I sincerely doubt you need 'a fresh install or an upgrade' to solve this problem, you just need to configure things properly. Being a UNIX Guy I don't know how it all works on Windows... have you verified that any environment variables needed are defined on the server? SYBASE and SYBASE_OCS from wha...

I personally don't see how any 'problem with DS' can generate an erroneous Oracle 'account is locked' message, but whatever...

Curious if that restart 'fixes' your problem.

Like Arnd said... um, what? Have you verified that you do indeed have a problem? That inserts should have in fact have been performed on your data? Do you understand how these 'dual action' actions work? I personally despise them. To me they are a crutch supporting bad job designs and should never b...