| Author |
Topic |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-03-03 : 07:35:22
|
| HiI have setup a step in SQL Server Agent to run a SSIS package that I have created. However the step fails straight away and refers me to the history log, which doesnt seem to show what the problem is.I've tried running the package manually through dtexec.exe and it runs through fine. Does anyone know what the problem could be?Thanks |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-03-03 : 17:10:27
|
| I had this issue on time and chased my tail for a day or two. I am not sure if this is your issue, my issue was that my source and my destination server were not on the same Port. You may also want to check the permissions level of your SQL Server Agent Service.Chris Shawwww.SQLonCall.com |
 |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-03-03 : 19:19:02
|
| HiI have managed to get all the packages apart from one running them as a server package instead of file system. The aim of the package that I am failing to run is to create an exported excel file with a datestamp within the file name.Does anyone know why this one would fail. I look in the history log and it states that it cannot open the file that it is trying to make, which is confusing as it hasnt made the file yet.Any ideas? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 22:16:27
|
| Where is the file? If it's on remote location, sql agent service account needs permission to access it. |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-03-04 : 03:32:15
|
| Its stored on the same server as the sql agent, as are all the the other packages. How would you set the permissions?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-04 : 22:47:43
|
| Not package file. Does step in the package access remote data file? |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-03-05 : 03:42:35
|
| HiAll the data is stored on the same machine as the server.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 22:43:13
|
| Who's job owner? Tried trace the job in profiler? |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-03-06 : 05:31:12
|
| Hi I have managed to get the package running through using a SQL Proxy.My only concern is that the proxy is based on credentials of an admin.I've tried creating a new login with less access rights and used this for the proxy, but this failed. I also made the new login an admin and applied it to the proxy, but this still failed.Does anyone know what kind of network issue this could be?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:21:18
|
| Still permission issue as said above. The account used needs permission on all files involved. |
|
|
|
|
Problem Running SSIS Package in SQL Server Agent