Click here to Skip to main content
14,550,454 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi frnds...

I created a new SSIS Package and deployed the same in the server.. it works successfully when i run the package in my machine through sql server management studio.... Now, what the problem is on another machine i connected the sql server management studio to the same server and connected to integration services.. I can saw the saved package but when i click execute button the message displays the access is denied because of the error code 0x...... what the problem is this... IF it is a permission problem or something else??
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

It seems like permission issue. Are you using Remote Path or anather drive in Package? If yes then is that user has access rights on those drive?

Have a look at given thread.
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/9cde6bda-6219-4f5a-be28-5208281394b8[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100