Need help running an SSIS package from a remote computer.
Hello. I created a DTSX package that works with our MS SQLServer 2008 R2 software.
It works perfectly from the machine in which MS SQL Server is installed. Can someone help me run the package from a remote computer?
SoftwareMicrosoft SQL Server 2008Microsoft SQL ServerSSIS
I have MS SQL 2008 R2 installed on a computer in our domain. I used SSMS to create a dtsx file, which I can execute on the computer than has ms SQL Server installed without issue.
The problem is that I need to be able to execute the same dtsx file from another computer in the workgroup that does not have access to the computer with the ms sql server installation.
I need to be able to do this without granting access to the ms sql computer.
Lets say I log onto the computer with the MS SQL Server installation as admin. All I need to do is click on the UpdateMyWebsite.dtsx file and the SSIS job runs, thereby updating my website.
So now instead of logging onto the compuer with the SQL Server installation I log onto another computer in the worgroup. I now need to run the UpdateMyWebsite.dtsx job. I've used a program named PSEXEC to do this before, but now I get an access denied message unless I make the user a domain admin, which I can not do.
Hope you have a solution!