Sftp Upload and Delete

We are currently evaluting the SmartFTP Client. Our requirement is as follows,
  1. Schedule a task to upload a zip file from a folder (For example : c:\ToUpload) once a day.
  2. The folder may also contain other folders which should be uploaded. Only the zip file should be uploaded. so I tried using Source as "C:\ToUpload\*.zip" but it didn't seem to work. Is wildcard allowed in the Source?
  3. The name of zip file is different every day. For example: Data_16092013_231819.zip, basically it has the date and time of file creation. So using wildcard would be the best option.Is there any other option that we can try?
  4. After the successful upload delete or move the zip to another configurable location.
Could you help if this is something that is possible is SmartFTP client. We are planning to buy if client meets our requirement.
 
Thanks.

When I use wildcard to upload files, the sftp fails with the following error:
 
[19:28:05] 1379935683>Operation Begin
[19:28:05] 1379935683>Resolving host name "X.X.X.X"
[19:28:05] 1379935683>Connecting to X.X.X.X Port: 22
[19:28:05] 1379935683>Connected to X.X.X.X.
[19:28:05] 1379935683>SSH protocol version reply. Client Id: SSH-2.0-SmartFTP
[19:28:05] 1379935683>SSH-2.0-OpenSSH_6.1
[19:28:05] 1379935683>Starting SSH session. Remote Id: "SSH-2.0-OpenSSH_6.1"
[19:28:05] 1379935684>Server Algorithm Suite
Key Exchange: diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
Server Host Key: ssh-rsa,ssh-dss
Client to Server Encryption: aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,aes192-cbc,aes256-cbc,arcfour,rijndael-cbc@lysator.liu.se
Server to Client Encryption: aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-cbc,3des-cbc,blowfish-cbc,cast128-cbc,aes192-cbc,aes256-cbc,arcfour,rijndael-cbc@lysator.liu.se
Client to Server HMAC: hmac-md5,hmac-sha1,umac-64@openssh.com,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
Server to Client HMAC: hmac-md5,hmac-sha1,umac-64@openssh.com,hmac-sha2-256,hmac-sha2-512,hmac-ripemd160,hmac-ripemd160@openssh.com,hmac-sha1-96,hmac-md5-96
Client to Server Compression: none,zlib@openssh.com
Server to Client Compression: none,zlib@openssh.com
[19:28:05] 1379935684>Selected Algorithm Suite
Key Exchange: diffie-hellman-group-exchange-sha256
Server Host Key: ssh-rsa
Client to Server Encryption: aes128-ctr
Server to Client Encryption: aes128-ctr
Client to Server HMAC: hmac-sha2-256
Server to Client HMAC: hmac-sha2-256
Client to Server Compression: zlib@openssh.com
Server to Client Compression: zlib@openssh.com
[19:28:05] 1379935684>Client Algorithm Suite
Key Exchange: ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group-exchange-sha1,diffie-hellman-group1-sha1,diffie-hellman-group14-sha1,rsa1024-sha1
Server Host Key: ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,x509v3-sign-rsa-sha1,x509v3-sign-dss-sha1,ssh-rsa,ssh-dss
Client to Server Encryption: aes128-gcm@openssh.com,aes256-gcm@openssh.com,aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-cbc,rijndael128-cbc,aes192-cbc,rijndael192-cbc,aes256-cbc,rijndael256-cbc,rijndael-cbc@lysator.liu.se,3des-cbc,arcfour,blowfish-cbc,cast128-cbc
Server to Client Encryption: aes128-gcm@openssh.com,aes256-gcm@openssh.com,aes128-ctr,aes192-ctr,aes256-ctr,arcfour256,arcfour128,aes128-cbc,rijndael128-cbc,aes192-cbc,rijndael192-cbc,aes256-cbc,rijndael256-cbc,rijndael-cbc@lysator.liu.se,3des-cbc,arcfour,blowfish-cbc,cast128-cbc
Client to Server HMAC: hmac-sha2-256,hmac-sha2-512,hmac-sha1,hmac-md5,umac-64@openssh.com,hmac-ripemd160
Server to Client HMAC: hmac-sha2-256,hmac-sha2-512,hmac-sha1,hmac-md5,umac-64@openssh.com,hmac-ripemd160
Client to Server Compression: zlib@openssh.com,zlib,none
Server to Client Compression: zlib@openssh.com,zlib,none
[19:28:05] 1379935684>Key Exchange Algorithm: diffie-hellman-group-exchange-sha256
[19:28:05] 1379935684>Server "ssh-rsa" host key fingerprint: DD:AB:69:BE:A6:DF:E8:B3:7D:35:AC:F7:07:DD:19:3B
[19:28:05] 1379935684>Key exchange completed.
[19:28:05] 1379935684>Requesting service "ssh-userauth".
[19:28:05] 1379935684>RTT: 113.763 ms
[19:28:05] 1379935684>Authentication request. Method: none
[19:28:05] 1379935684>Server supported authentications: publickey
[19:28:05] 1379935684>Authentication request. Method: publickey
[19:28:05] 1379935684>User authentication successful.
[19:28:05] 1379935684>SSH session established.
[19:28:05] 1379935684>Detected Server Software: OpenSSH
[19:28:05] 1379935684>Opening channel 0.
[19:28:05] 1379935684>Channel successfully opened (Local=0, Remote=0).
[19:28:05] 1379935684>Requesting subystem "sftp" (Local=0, Remote=0).
[19:28:05] 1379935684>Sending FXP initialization. Protocol version=6.
[19:28:05] 1379935684>SFTP protocol version 3
[19:28:05] 1379935684>Getting properties (Date modified, Size) of "C:\Test\*.zip"
[19:28:05] 1379935684>Unable to obtain properties of file "C:\Test\*.zip". Error=0x8007007b
[19:28:05] 1379935684>Transfer failed.
[19:28:05] 1379935684>Operation End
[19:28:14] 1379935694>Operation Begin
[19:28:14] 1379935694>Getting properties (Date modified, Size) of "C:\Test\*.zip"
[19:28:14] 1379935694>Unable to obtain properties of file "C:\Test\*.zip". Error=0x8007007b
[19:28:14] 1379935694>Transfer failed.
[19:28:14] 1379935694>Operation End
 
Also if I don;t specify the desitination file for example: specify "/home/miopftest/upload/" instead of "/home/miopftest/upload/data_16092013_231819.zip" I get the following error,
 
[19:31:36] 1379935881>Operation Begin
[19:31:36] 1379935881>Getting properties (Date modified, Size) of "C:\Test\data_16092013_231819.zip"
[19:31:36] 1379935881>Resolving path "/home/miopftest/upload".
[19:31:36] 1379935881>Path successfully resolved to "/home/miopftest/upload".
[19:31:36] 1379935881>Getting properties (Date modified, Size) of "/home/miopftest/upload"
[19:31:36] 1379935881>Getting attributes of "/home/miopftest/upload".
[19:31:36] 1379935881>Attributes successfully obtained.
[19:31:36] 1379935881>Source File: Size=2419204, Date modified=2013-09-23T08:22:47
[19:31:36] 1379935881>Destination File: Size=Unknown, Date modified=2013-06-07T06:33:43
[19:31:36] 1379935881>No rule matched. Default Action="Overwrite".
[19:31:36] 1379935881>Uploading file to "/home/miopftest/upload".
[19:31:36] 1379935881>StartPosition=0, EndPosition=0.
[19:31:36] 1379935881>4 Failure
[19:31:36] 1379935881>Transfer failed.
[19:31:36] 1379935881>Operation End
 
 
Could you help if I am missing any configuration ?