How can I remotely run a dtsx file that is local to the SQL Server
Posted on 2008-10-10
I have a dtsx file saved to a shared folder local to the SQL Server. If I RDS into the SQL Server, browse to the file and double-click it, I get the Execute Package Utility window where I can click Execute and it works perfectly.
I want to allow one of my users to execute this file from their PC without having them RDS into the SQL Server. I tried browsing to the file remotely and double-clicking \\SQLServer\Share\file.dtsx but that just brings up the local Execute Package Utility window and executing the file from there does not work.
I read something about using a batch file. Has anybody been able to do this and if so, could you please instruct me how to do it?