InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:33:57 GMT20http://www.sqlservercentral.com/Forums/Topic1422251-1291-1.aspxthanks for the reply and the willingness to helpI'm not familiar with PowerShell or other scripting language besides sqlany assistance will be wonderfulsamThu, 21 Feb 2013 10:04:07 GMTsam-433147http://www.sqlservercentral.com/Forums/Topic1422251-1291-1.aspx[quote][b]sam-433147 (2/20/2013)[/b][hr]i run a Tsql query that move's a file from one computer to anotherset @sql='move '+@file1+' '+@file2EXEC master..xp_cmdshell @sql , NO_OUTPUT now, i want the query to wait until the file arrive's to its destination and onlyif FileExists to continue the next actionis there something like shellwait until the xp_cmdshell finish is job?thankssam[/quote]It might be possible, but a feat like this is far easier to achieve in PowerShell, SSIS, .NET...pretty much any other programming or scripting language besides CmdShell. This is not to mention that accessing the file system from T-SQL brings with it a ton of baggage when it comes to security and auditing. Is moving this process out of T-SQL an option for you? If so, I would strongly recommend changing the approach and disabling xp_cmdshell on the Instance if at all possible. If you want help implementing this task in any of the technologies I mentioned I'd be happy to assist.Thu, 21 Feb 2013 08:14:45 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1422251-1291-1.aspxi run a Tsql query that move's a file from one computer to anotherset @sql='move '+@file1+' '+@file2EXEC master..xp_cmdshell @sql , NO_OUTPUT now, i want the query to wait until the file arrive's to its destination and onlyif FileExists to continue the next actionis there something like shellwait until the xp_cmdshell finish is job?thankssamWed, 20 Feb 2013 12:39:48 GMTsam-433147