ssis package fails when run under sql server agent

Tech-Archive recommends: Fix windows errors by optimizing your registry

i've got an ssis package that runs fine when i run it from within visual
studio, but fails when run under sql server agent. when i run the package
from visual studio, i'm logged in under the same account as the sql job's
owner (both the admin account). the step it's failing on is when it needs to
read files in a folder on a separate machine, but this machine is in the
same domain and the folder in question has ntfs security permissions set to
allow the admin account full control over the folder.

it seems like this problem is related to how's running the script, but it
looks like the necessary permissions are in place.

anybody got any ideas about what i'm missing?

tks



.

Relevant Pages

  • RE: Run a ssis package on SQL Server 2005 Error
    ... Your SSIS package failed to run from a SQL Server Agent job step, ... This is most likely a known issue in SQL Server 2005, ... Set the SSIS Package ProtectionLevel property to ServerStorage ... You can then modify the SQL Server Agent job step command line to include ...
    (microsoft.public.sqlserver.dts)
  • Getting a SSIS Package to run under SQL Server Agent Scheduled Jobs
    ... I created a SSIS Package 2 ways. ... I used the Import/Export wizard to import a MS Access Database into ... I scheduled the job with the run as SQL Server Agent ... Service Account, and owner as my domain account. ...
    (microsoft.public.sqlserver.dts)
  • NEWBIE - cant run SSIS package in SQL server agent scheduled job?
    ... I have a SSIS package that runs fine in Visual Studio. ... But if I put it in a scheduled job in SQL Server agent, ... The package does have an ODBC connection in it. ... The connection uses a SYSTEM DSN connection to get data from another source on another machine. ...
    (microsoft.public.sqlserver.dts)
  • Re: olap on 2005
    ... > how to run automatic Cube processing on 2005? ... I did this by creating an SSIS package using BI Studio, ... package using the generated deployment utility, ... that package using SQL Server Agent. ...
    (microsoft.public.sqlserver.olap)
  • Re: VS 2005 CPU cycles
    ... Always restart it. ... Schneider ... > i am having the same problem whilst running an SSIS package in VS ... > then Visual studio exits with fatal error message. ...
    (microsoft.public.vsnet.ide)