Click here to Skip to main content
Rate this: bad
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
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

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

  Print Answers RSS
0 OriginalGriff 7,105
1 DamithSL 5,079
2 Maciej Los 4,866
3 Sergey Alexandrovich Kryukov 4,617
4 Kornfeld Eliyahu Peter 4,384

Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2014
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