DSXchange

There's one here.

saadmirza wrote:keeping in mind that Rnd() function will not generate random number twice...

What makes you think that statement is true? Kind of flies in the face of what the term 'random' means.

Yah, the addition of this seems to enable using Perl from your DataStage jobs, which is what it uses to do the log parsing from what I've read. I'll see about importing the .dsx they have provided, but don't recall seeing documented anywhere the need to register any plugins - even though that does m...

I need to get ClickPack installed for one of the developers here on our dev server and I don't know beans about it other than what it purports to do. At this point I'm wondering if there is more to it than simply mounting the cdrom and running the 'install.sh' script in the 'clickpack' directory? I ...

Either precreate it in the Manager (File/New Category) or just create it on the fly when saving the job. A backwards slash denotes a subcategory.

databin wrote:Save job 'xyz' in the directory Jobs/newdirectoryname.

Actually, it would be 'Jobs\newdirectoryname'.

Maybe you haven't gotten a 'reasonable answer' because your question is practically incomprehensible. Going off the "I want to run sp and thatis it" part, why not just write a batch file to call your sql tool of choice and execute the stored procedure? Run it from a Routine Activity stage in the Seq...

In other words, directly in the Key Expression.

I'd be happy to help as well - as long as you promise not to laugh at the numbers we get off of our [cough] 'Super' [/cough] domes, that is. Is it worth waiting for the Sept Hawk release and the new repository? Process metadata may be easier to extract in that release then it is in the previous rele...

Search the forum for 'DSX Cutter'.

Ask your DBA.

:D Something similar going on at the company I'm currently working for. Salespeople are tracked and compensated by two different systems. The tracking system is very cool and quite flexible when it comes to dealing with all of the tricks people have come up with to 'beat the system'. On the compensa...

Not specifically. There is a check box to include errors in the outgoing email, but it is basically excerpts from job logs. There is no support for Job Parameters in the Notification Activity stage but I can't say for sure regarding environment variables.

Give it a try, let us know.

The 'invalid character' is the semi-colon you put at the end of the SQL statement... take it off. View Data will work with it there, but the job won't run.

PeopleSoft by chance? In a PeopleSoft instance, all application tables are owned by SYSADM - and that can be 20 or 30 thousand tables.

You must learn patience, Grasshopper.