SQL 2005 SSIS

This should be simple, but its not. I have a simple package that
selects data from one server and inserts it into another. It works
interactively but I cannot get it to run scheduled. I have tried
changing the SQL Agent to my login and it fails. The only message that
I get in history is that the package failed. I added error trapping in
the package but it doesn't catch anything, as the package does work
interactively.

After I create and save the package is there something else I need to
do before I can schedule it to run?

Pete

Hello pjcwik (AT) gmail (DOT) com,

You more than likely do have an issue with security. How are you executing
the package in agent i.e. what job step type. Have a look here for some
more ideas about how to get better error details

http://wiki.sqlis.com/default.aspx/S...dPackages.html


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I am having a similiar problem. What account Id will a job execute
under when it pushes data to a table in another server?

Joe

That can depend

A good place to start though is here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d728a2f5-6a2d-40f7-aba7-ed51b930072d.htm

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


<joevanderh (AT) gmail (DOT) com> wrote

I am executing a job on one server and it will run fine if the source
and target are on this server but it fails when trying to load to
another server.

I am not sure what Id SQL Server Agent is using when connecting to the
other server.

Joe