Link to home
Start Free TrialLog in
Avatar of pcalabria
pcalabriaFlag for United States of America

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?
Avatar of Marcus Keustermans
Marcus Keustermans
Flag of South Africa image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pcalabria


@Marcus  Thanks for the response however either it does not address my issue or I don't understand the information.

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!
Marcus.. other things have come up and I have not had a chance to try... In time I will.. I will not forget..thanks