pcalabria
asked on
Need to run SSIS package from a remote computer
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?
Thanks.
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?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Marcus.. other things have come up and I have not had a chance to try... In time I will.. I will not forget..thanks
ASKER
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.
Example:
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!