Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2013-08-27 : 14:32:07
|
| Greetings all,I have setup an ssis package running from a scheduled job to ingest excel file from an UNC path location. The ssis package runs using a config file to dynamically change path location depending on environment.Job is deployed to production, job runs with success but the files at unc share still there. running sql job as sql server service account. it has full access to share. Anyone ever run into such an issue?If you could please help me out on this.Thanks<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-08-27 : 23:12:09
|
| figured it out. always ask your sys admin or storage folks "show me the perms on the shared folders"<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-28 : 03:17:45
|
| you should have got an exception in log indicating permission issue. Did you check log file?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssis not picking up from UNC