DSXchange

I figured out that if I called the DSaveAsBmp.bat via the DS job from another server, then the .bmp's will all generate with white backgrounds. So I installed all the documentation generation pieces on my DEV ETL DataStage server and use that server to document my production server jobs.

Hi all. I have successfully downloaded Kim Duke's report generation scripts/jobs (very slick tool btw). When I manually execute the DSaveAsBmpDriver.bat with all the necessary parameters, I get the desired .bmp files output in the location I want them. However, I have created a DS job which utilizes...

Thanks guys, executing the SETFILE command allowed me to then run the SETFILE command on my hashed file.

Yes, I manually created it using a pathed hashed file with a job parameter...

No, I'm on Windows Server, and I'm running it from the Administrator...

I'm new to using the command interface, and I'm trying to execute the ANALYZE.FILE command on a hashed file named "hsh_Staging_2." The syntax I've entered verbatim is as follows: ANALYZE.FILE hsh_Staging_2 However, I receive the message: "Illegal option found on command line: "hs...

Why is it a different thread? The individual that added his own problems to the original thread discussion had an issue with DRS as well...I thought this would be the perfect place to post in the event that the problems were being caused by the same underlying issue anyone in the future could possib...

We are experiencing a similar issue except that we are having the problem with the RDBMS stage. The job works fine in 7.5, however when we migrated it to 8.1 and tested it, same error message as stated in the top of this thread. I was able to convert the RDBMS stage to an ODBC stage and got the job ...

I am looking to allow a sequence I have built to finish running all remaining jobs in its sequence, but abort upon completion if at any point in the sequence one of its jobs has failed. I found this thread which very closely resembles what I am looking to achieve: http://dsxchange.com/viewtopic.php?...

Doing anything... strange... in the transformer in your derivations? Using stage variables? Etc. If you rerun the jobs with the same input data, does the same error occur? Trying to assertain just how random your random is. No, the transformer is simply passing along the fields from source to targe...

All: I have 3 very simple jobs each designed as such: Seq. File ------> Transformer ------> Seq. File The purpose of these 3 jobs is to take 3 separate flat files all having the same file format and merge them together into one flat file. The first job clears out the target file while the second and...

Okay, I believe I figured out why the stored proc would not execute, and have discovered a very simple workaround to this issue. After gaining access to the code for the stored procedure in question (that I was executing in the After SQL tab in the DRS stage) I discovered that there was something th...

DBAs? What are DBAs? :D I'm about as close as you get to one here in my organization, and I'm far from being a DBA... I'm not sure how 'Robust' the sproc is, it was created by an outsourced development boutique and I've not had the agonizing 'luxury' of obtaing the source code yet. I'm going to work...

Absolutely right. Using:

C:\Progra~1\Ascential\DataStage7.5.2\dsjob ....etc.

(without the quotes) works as well.

Thanks again.

Thanks ArndW. Explicitly coding the location of my local dsjob.exe did the trick. As a helpful tip for anyone else that may come across this issue, this is exactly what my dsjob command line looks like now: "C:\Program Files\Ascential\DataStage7.5.2\dsjob" -server myServerName -user myUser...