Hi, I have a SSIS package that executes a SQL Task.
It does a simple insert to a table. It works in the BIDS.
When I deploy to SQL Server (same machine) it fails to execute the SQL Agent
Job
I have tried as many combinations of sa vs windows authentication, file vs
server deployement as i could think of.
I must be missing something simple.
?
What method should i used to see what caused the failure? The history logs
stop at the fail of the job. I would like to see why the Execute SQL Task of
the package failed.
? I'm guessing this is a permissions issue since it works in the dev
environment. Is there a sample Hello World package available that I can use
to test?

Thanks

Hello,

You could check the sqlagent.out under %programfiles%\microsoft sql
server\mssql.1\mssql\log. Also, you could edit step property of the job to
output the job failure to a output file.

If you installed SQL 2005 samples, you could find SSIS sample include
executeSQLsatement samples.

To troubleshoot the issue, you may want to change the job owner to a user
with SQL server admin role. Also, you may want to change SQL agent service
account to a user with local admin rights to test.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------