manu

This did not make any change it will only give you the whole name of the machine which is not my problem. The problem is at the

exec

all that is taking care of if you read the posting. i just need help with the script i posted. thanks.

My workstation name is TXCDTLT01HO2451 and I am getting the first 6 char TXCDTL

Thanks a million.

Thanks for your input.

Yes I will grant my dba(-group) sysadmin (windows) rights for the sqlserver instance !

what if I wanted to create a sql account and grant read access...

I have the delete part now, but can you help with the dumping of the file that you talked of to a folder.

yes I will transmitt more than one file in a day. Actually I will transmitt the transaction logs from the backup drive to a folder in the remote server....

I hope I am nothing asking a stupid question. But where in the script do I put the source and destination directory of the files to be copied

Thanks I will try it and let you know. regards

Thanks for your reply. I have not used ssis before and not sure if the tool will build the script for the FTP part if not can you help. Thanks...

I mean transaction log shipping failures that are not applied to the destination server.

we have servers that are in production now and I have a task to move those databases to a remote server through FTP. In the remote server we will like...

Can someone reply to this post and even if they don't have all the answers to the question, I will aprreaciate any feedback