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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-03-01 : 06:17:57
|
| Hello,The SSIS package runs successfully on my local machine as a job.It accesses the network files and copies them to other network folders.Now I have placed this package into the Dev machine and configured the job to start the package.It runs successfully without error but the files do not get moved.I am trying to find out if the account that runs the job has iindedd got the permissions to access the network files...Until then, do you know why I do not see a failure message why the job runs. I ask this question because the jobs shows success and yet the files do not get moved.Any thoughts please?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-01 : 11:36:32
|
| You're probably right that it's a permissions issue. Do you have workflow constraints that allows the SSIS to continue on error? |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-03-01 : 17:05:53
|
| Not sure, how do I check this please?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-01 : 20:01:00
|
| open the package in BIDS. are all of the steps connected by green (success) arrows or are some connected by red ones? |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-03-02 : 05:40:57
|
| only green |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-03-03 : 05:09:22
|
| solved as the problem was permissioning. thank you all. |
|
|
|
|
|
|
job