DSXchange

Thanks for the info. I had print statements in then procedure as I was testing them in a sql window and put the whole thing in the executable procedure. I'll take that out.

Thanks, Again.

Steve

I am running a job that calls a procedure that updates, deletes, and inserts info into 45 tables. Each time the procedure executes it writes informational messages about the sql statement it performs. This is great when you are debugging the job, but in production this job will execute about 100,000...

Kenneth, Here is the code I used. The parameter Filename is not being populated correctly. I listed the log messages after where they occurred. Seems it doesn't like something relating to the VOC. Also is there some way to see what value Filename takes on each time. If I knew it was actually going t...

Guy, Thanks for all your help. Below is the code I'm using to try and pull the latest file. I'm not very good with loops so don't be to hard on me. Steve *Loop through Source Parm Dir to pull the most recent file Call DSLogInfo("Setting up Dynamic Array Loop to pull the most recent file from So...

Thanks for all the input. ogmios code with the CHAR(34) worked. The job was successful.

Thanks Again!!

Thanks for the input, I was starting to go crazy!

When using that coding this is the error that I get. Any suggestions?


CTRL_JOB_RGS..JobControl (Job Control): msgs is System error 1202 has occurred.


An attempt was made to remember a device that had previously been remembered.

Thanks

Is this how the coding should look?

Does it matter that part of the path has a space "FTP TOTE" instead of "FTPTOTE"?

Call DSExecute("NT", "net use K: \\Secureftp\FTP TOTE /PERSISTENT:NO", msgs, rtncd)

Thanks.

Hey all, I have created a process that uses a control job which directs a file to be copied to a landing area, unzipped, parts copied to main folder, process the data from the main folder, clear the landing area and main folder, and archive the zip file. I have code to map to drives that contain the...

Hey, Below is coding that I have in a control job. It is suppose to map a remote drive so I can get and copy files from the remote (I use a batch script and parmeters). As you can see from the error at the very bottom of this post that it does not recognize the drive. I have the drive mapped on the ...

How do I call a Stored Procedure in DS. I am trying to update a datetable with the most recent date. My job uses that date in determining what data to pull from another table. I have included the matching criteria in the selection tab as follows: sql_simulcast.dbo.Settlement.Location = 'CAL' and sql...

Hi,
The platform for the server is windows 2000. The client is WindowsXP.

Thanks for the replies. Here is the piece of coding that I using to try and connect to an ftp site along with the .bat file. I made a couple of changes and the job get hung. Any suggestions!!! *Copy bay file to a local drive Call DSLogInfo("Copying files by calling batch script via DSExecute co...

I am using a control job that reads parameters form a parameter.ini file. The server job is to get a zip file, unzip to a folder, copy certain files to another folder, and write those records to a table. My trouble is getting the zip file from an ftp site. I have created a .bat file which the contro...