Sorry, this is the actual result:

You entered mission ID BKSF05-253. If you see any errors below, please check

the existence of the files manually or check the mission name.

File not found...

Thanks all. This is what was logged as a result of the previous two suggestions:

You entered mission ID BKSF05-253. If you see any errors below, please check

the existence of the...

The files don't already exist in the destination directory. I tried using the /Y switch:

C:\winnt\system32\xcopy.exe /Y "c:\Inetpub\ftproot\adam\MisBack\Bais\%1.AIS" "c:\Inetpub\ftproot\adam\Mission\"

and that did not work.  When I run the batch file from...

Tried both Dave and Karl's suggestions and neither worked. Still getting the same entry in the miss.log file. Any further suggestions?

You entered mission ID BKSF05-252. If you see any errors below, please check

the existence of the files manually or check the mission name.

Sara, what exactly do you mean by run "it" from the command line? If you mean the line of code,

c:\ReloadMission\Rmission.bat BKSF05-254 , then as stated previously, it does work from...

Thanks for your help. I would still like to see this work using code similar to my own. Could you give my code a rearrange to show me how this...

I apologize for the confusion Merrill. I will explain further:

The @status variable is used to represent, (A)dd, (U)pdate or (D)elete. If the application passes in 'A', then a...

SET NOCOUNT ON
SET ANSI_NULLS ON

IF @status IS NULL or @status = ''
 BEGIN
 --No target status code specified for INSERT, UPDATE, DELETE
 RETURN (1)
 END

ELSE
 
 --Check to ensure the target code does not already exist...

Thanks for the reply. However, can someone give me a brief explanation as to what this UDF does? Will it replace chraracters such as #, &, %, etc? Its not just...

Does anyone have an example of a UDF that I could use?

Thanks all. But the client requires that the date/time be stored in the Unix format. I am currently using the numeric datatype. Which would be better or more applicable, integer...

Good day Sarah. I have the very same questions!

Thanks Brian. I will give that a try. Much appreciated!

I wanted to open an FTP connection , delete the file and then close the FTP connection. Your example uses a mapped drive....is there way to do the same thing...