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 |
|
rnln
Starting Member
3 Posts |
 Posted - 2011-08-01 : 20:20:52
|
| Hi, Basically, what I need to do is to import data from .xls file to a table, and have it scheduled weekly at a certain time.What I have done was created an SSIS package using MS visual studio, by a "data flow task". Test ran it there and it works fine, saved it.Going to the SQL server management studio, right clicked on "Job" to create new job and step, set a time to schedule it. Then I right clicked to "Start Job at Step", it gave me an error:- Start Job 'xxx'. Success.- Execute job 'xxx'. Error.Reading the history log file, I found that the code error is 0x54b, SQLState 42000, error 15404. Desc is: Unable to determine if the owner has server access.Does anyone know what I missed? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
rnln
Starting Member
3 Posts |
Posted - 2011-08-02 : 15:16:32
|
| visakh16,Thanks for the link. I created a credentials and proxy account, then set the "run as" to the new proxy account, but still have the same problem. Anything else you can think of? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-03 : 01:33:43
|
| whats the protection level you've set in package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rnln
Starting Member
3 Posts |
Posted - 2011-08-04 : 19:50:30
|
| group admin.I asked someone else to use his account in the credentials and it works. That proves it's my permission level.Thank you. |
|
|
|
|
|
|
|
|
Please help with SSIS and job agent/step.