Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SSIS
Hi All,
I have created a ssis packge on sever 2010 it is working fine in local system.but i moved file to fileserver in ssis i got a problem with ssis package is accessDenaied.
Please let me know .
Posted 7-Jan-13 21:03pm

1 solution

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

Solution 1

Check permissions of the SQL Server Service Account(the user executes job)...
You can create proxies (with your account) to execute the job also. For this you need to add Credentials first, then create Proxies, google on creating credentials/proxies will get you detail steps
  Permalink  

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

  Print Answers RSS
0 Sascha Lefévre 485
1 Sergey Alexandrovich Kryukov 325
2 Maciej Los 240
3 Abhinav S 174
4 Peter Leow 120
0 Sergey Alexandrovich Kryukov 6,773
1 OriginalGriff 6,311
2 Maciej Los 2,692
3 Peter Leow 2,654
4 Abhinav S 2,562


Advertise | Privacy | Mobile
Web04 | 2.8.150414.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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