I want to run a SSIS package which is on my local machine. To run the package I require use a job in SQL Server; but the job is in a different server. So when I’ve executed the job it shows me the following error:
Description: Failed to open package file C:\localpath\process\package.dtsx” due to error 0x80070003.The system can not find the path specified.[..]
I placed the package in to the server where is the job, but did not work because that server does not contain Visual Studio.
Also, I modified the path adding the localhost Ip V4 direction (I understand this is the localhost direction) \\ipDirection\path but not worked.