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 |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2010-02-24 : 18:53:43
|
| I successfully created a package in SSIS for the first time. I ran the package manually within SSIS and all of the expected behavior resulted as needed. HOWEVER, then I made a SQL Agent Job with this package as the only step (I'm trying to export data to a flat file), I get an error:0xC004701AIn the notes, it says the job was executed as KNS\dgreen, but I am KNS\bkingery. We should both have all the same permissions...is there something wrong with this? Is there a way I can have this run with my user/login? |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-03 : 12:50:04
|
| If you ran as SQL Agent JOB, Double click on the job ---> Goto "Job Steps Properties" there is 3 combo "RUN AS" you can set it as your and try.With RegardsSR |
 |
|
|
|
|
|
New Package and SQL Server Agent