October 14, 2015 at 3:06 am
Ok shortly we have the following scenario
Server A & B, both running Windows Server 2008,both having SQL Server 2008 r2.
Both the service accounts used to run jobs on A & B have full rights on share C1 on a fileserver C.
Changes made to security.
Service Account on A regains full rights.
Service Account on B only has read rights.
Test Package
For each file loop hardcoded to share C1
Exec sql task that just inserts a value in a test table.
22 files in C1.
Ran test package in job form on Server A;test table contains 22 records afterwards.
Ran test package in job form on Server B;test table contains 0 records.
Can anyone explain why this happens & how I could capture this, also I need to make sure I don't get errors when no files are in C1.
October 14, 2015 at 3:16 am
If you're running the package interactively (in BIDS/SSDT), you'll be able to see the error messages and work it out from there. If it's running from a job or similar, you need to make sure there's some sort of logging enabled, so that you can capture the error messages.
John
October 14, 2015 at 6:23 am
Hi
Service account on B needs Read & List Folder or Read & Execute permission to do that.
Regarding the file exists validation, you can check it by Script Task before looping.
Br.
Mike
October 15, 2015 at 8:39 am
ok,sorry for not being able to respond earlier
yes I came to the same conclusion,I just find it odd that I was no getting any errors
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply