Is there anyway to move and rename files without using xp_cmdshell??
Posted on 2007-03-20
I have created a couple of DTS that generate execl spreadsheets with data from production. The problem is I need to archive these spreadsheets, rename them, move them to folders, etc, the problem is that I cant use xp_cmdshell to do so because of security reasons. Our infrastructure support doenst want anyone use it since it is to powerful and creates to many security issues. Is there anyother way to do what I need to do with these files without using xp_cmdshell? Either using SQL, VB, etc.