January 18, 2007 at 1:06 pm
I created a simple export from DB2 / import tbl to SQL Server and saved it as a SSIS package. I then went into SS Agent to setup a job to be scheduled to run and it fails when I manually run it. The error says the job failed and to 'See the history log for details'. Where does this history log go and what would be its name ? I am assuming it is some ID permissions issue but I have no idea where to look for this history log. It isn't in the LOG folder on the server and I kicked it off in MGT Studio on the server.
I am running SQL 2005 SP1 Stnd Ed. with 2153 hotfix patch on 64 bit.
January 22, 2007 at 8:00 am
This was removed by the editor as SPAM
January 22, 2007 at 8:45 am
Hi,
This sounds like it is realted to the package protection level. Check this out.
http://support.microsoft.com/kb/918760
Regards
Daniel
January 22, 2007 at 8:53 am
On your job step check which login is used is used to start the job. If it's the SQL Agent service account, make sure the account has login on the servers or access to the directory you are trying to get your files from.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply