| Author |
Topic |
|
bondwiththebest
Starting Member
46 Posts |
 Posted - 2009-02-23 : 19:43:10
|
| Hi everyone,I am having problem with scheduling my SSIS package with sql jobs. It throws errors because of the shared path like \\Mycomputer\d$. I have did some research and they say SSIS doesn't like shared path that much. It runs with VS but not using sql jobs. Is there any other way to run the package using Sql jobs??? I even tried to run using batch file by running through command line but no luck!! If you can help me that would be great!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 19:51:28
|
| SQL Server Agent Account should have access to shared folder. |
 |
|
|
bondwiththebest
Starting Member
46 Posts |
Posted - 2009-02-24 : 08:16:42
|
| Hey, I am not that familar with Policies and all, can you tell me how to do that one ?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 09:44:03
|
quote:
Originally posted by bondwiththebest
Hey, I am not that familar with Policies and all, can you tell me how to do that one ??
Can you check securities inside your shared folder? |
|
|
|
bondwiththebest
Starting Member
46 Posts |
Posted - 2009-02-24 : 11:26:39
|
| I dint get that one, What securities does it need to have ?? I mean Do I need to create a new account of the sql sgent on the shared folder to have full access?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 12:51:44
|
quote:
Originally posted by bondwiththebest
I dint get that one, What securities does it need to have ?? I mean Do I need to create a new account of the sql sgent on the shared folder to have full access??
Nope, the account used by sql agent should be given access to folder. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 12:53:22
|
| What is your SSIS account running on? Domain account/Network Services or Local system a/c? It won't work if local system account is chosen. Answer this first. |
|
|
|
bondwiththebest
Starting Member
46 Posts |
Posted - 2009-02-24 : 13:54:27
|
| yes, my ssis pacakge is running locally and sql agent is running locally , we dont use domain. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 14:02:35
|
quote:
Originally posted by bondwiththebest
yes, my ssis pacakge is running locally and sql agent is running locally , we dont use domain.
Then it can't use Network shares. |
|
|
|
bondwiththebest
Starting Member
46 Posts |
Posted - 2009-02-24 : 15:37:43
|
| Sorry, I take it back, my SSIS account is running under network services and my sql agent is running under local account. I changed the Sql agent to network services and it failed to start up , so i changed to administrator account. So doesnt the administrator account have the full permission ?? Shouldnt it able to see the shared path??? |
|
|
|
|
Shared path in SSIS