DSXchange

The last script: (I'm working with this) #!/usr/bin/sh ################################################# # Este script manda correo a traves de sendmail # # con attachment # ################################################# # Recibe los siguientes parametros # # 1: Remitente # # 2: Destinatario # # ...

Well, I have created a script to do this (google, another scripts, several RFC papers help me) This is the script, use it if you want to.... (spanish used, it's my language) #!/usr/bin/sh ################################################# # Este script manda correo a traves de sendmail # # con attach...

Thx for replying, 7.0 (I know it, I know it....!!!) So, It won't be possible this way.... I'm trying to do this from the "Job Control" (the job has no stages, I'm using only the job control to manage it....), so I wonder if I can do something like: result = ExecSH("my_sendmail_sh"...

Hi all there! I have a job, and it checks if a file has something in it... When the file is not empty, I use DSSendMail to (duh!) send an e-mail to someone.... But I like to know how I attach the file in the mail...... I have read a lot about it, and have read about the dssendmail_template.txt (I kn...

Hi all I'm creating a hashed file from a query to an Oracle DB. In another job I have the following: OCI Stage ----> Transformer----->OCI Stage | | hashed_file I'm trying to validate the records...so the records that are NOT in the hashed_file get inserted into the second OCI Stage but when I run th...

ps. Next question: are you 100% certain the table the job is populating is the exact same one you checked in the analyser tool? Easy to check the wrong database or schema or whatnot. ... It's working now, the SQL Admin had moved the tables and ODBC definition to another server, but he didn't tell a...

Are you certain you commited the deletes? ... Yes sir.... the last test I did, I put a ODBC Stage with the option "clear the table, then insert rows" It worked...... Now... IT'S SUPPOSED I have data in my table..... but I checked out with a simple query in sql query analizer.... and it di...

Hi all there! I have a problem with my SQL ODBC.... I deleted a table info (because I need to insert new data) in my development SQL.... (delete from table).... Now, I have a job that validates the MAX(id) from this table and determines if there are new elements or not..... Since there is no data in...

Solved, the user and pass are in a shell file (which it's opening the FTP)

Thx!

ray.wurlod wrote:No.

One site at which I worked edited the log entry in an after job subroutine to mask the clear password. ...

OK, That sounds nice... how can I do it?

Hi all, I'm actually running a job that requires a txt file (this file is in a diferent server), so I'm using a FTP in the UNIX shell I call the shell with something like this: Argget.sh #Archivo# #Usu# #Pass# The shell works fine, it transfers my file and all is working ok. THE ISSUE IS: If I doubl...

It was a patch issue...
(my DS administrator had no clue about it)

Thanks all!

I have a DS client issue... I have a sequence, it calls several jobs; if I use right-click and choose "Open job" it gets opened without trouble. But if I use double click (on the sequence) or right-clik and "Properties" nothing happens.... Why? What could be happening? Greetings,

Thanks for you reply,

I'm actually accessing it by FTP. I just wanted to know if there's something wrong.

Thanks!

Hi all there, This time my problem is that I want to open a txt file located in a Windows server (shared folder, and open permissions). I've tried typing in the path "\\My_server_name\file.txt" and "\\10.10.10.10\file.txt" (with real IP Address). But I continue getting the DSD.SE...