DSXchange

But I am not able to combine the XML output with the fields in CSV before inserting into the Database. Two steps. One to 'create the XML' and stage it in a hashed file (typically as a chunk) keyed in such a manner as to match your incoming csv's key fields. Then stream the csv files in again, pick ...

He knows that, he's just being a smarty pants... and in a round about way saying that you should spell things like that out a little more. There are plenty of people here who wouldn't have a clue what you meant by "try DS.TOOLS 2".

Those xcopy commands certainly should echo out what they are doing and be captured in the log. What exactly do you have in the Command and Parameter options inside the Command Activity stage? I don't see anything obvious. Perhaps some bread crumbs would help... add echo statements at key points, in ...

Welcome aboard. :D How are you calling it 'from a job'? Are you passing in fully qualified paths for each directory? What happens if you comment out the '@ECHO OFF' and capture the screen output into you job's log? That may help figure out what is going on. However, the most common problem is the us...

Musta missed this one.

'Closing' is also known as 'Crashing'. You are getting a CTD or a Crash To Desktop. This is a known issue for which a patch exists. I don't recall the Ecase # off the top of my head, but you can download it from the IBM eServices website as long as you have a logon there: m Or talk to your Support p...

From what I've seen, you as an ETL developer may get sucked into the BI world if you end up needing to build marts or 'reporting tables' for them. Other than that, not so much.

How are you doing your job scheduling now? Not for this, but in general. Through the Director, you can simply 'Add to Schedule' 12 times using the proper date in each month. Or an Enterprise Scheduler like Control-M could do this easily. But I assume you somehow want to leverage this 'run_date' in y...

You don't have to give, but you could give: Call DSLogInfo(SystemOutput,"1.sh") The second argument is the Calling Program Name and should be a literal, so put quotes around it. Check the online Help. When you do this 'for real' be much more careful with your spelling, or at least ...

No problem. How about a rating and marking the thread as Resolved?

To continue my example: Call DSExecute("UNIX",CmdString,SystemOutput,ReturnCode) CmdString is the command to execute, SystemOutput is a variable that will capture any screen output, anything echoed from the command and ReturnCode is the variable which holds the exit code passed bac...

Relative paths. You should 'cd' to the directory you want to find these .txt files in before you list it out - unless you are expecting to farm the current job's Project directory. Are you? And if you always 'exit 0' you'll never know if anything went wrong expect by visual inspection of the log ent...

Can't you do that in the 'Open Command' area, or whatever it is called?

You build a complete 'command string', parameters and all, and pass that to DSExecute for it to run. We can't just 'give you the command' as each would be different. Use the concatenation operator - the colon (:) - and put together all the same parts you would put on the command line if you ran the ...

First question that jumps into my mind is - do you know if they are using the PeopleSoft PACKS with DataStage for this, or are they accessing it directly, going directly against the source database? For direct access, then not only would you need all of the 'normal' areas of knowledg of ETL in gener...