NEWBIE - can't 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, it won't run.

Both VS and SA use the same account to run.

The error I get in the logs is an ODBC error.
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.
I am simply using Windows authentication and VS is running under account "x".
the SQL Server Agent service is also set up to run under account "x".

Yet the error message says the driver cannot be loaded.

Is there perhaps and environment variable problem???
I believe the actual ODBC driver for this is on a network drive. Perhaps the network drive is not "mapped" within the SQL Server Agent service????

Anyone have any suggestions?
Thanks


.

Relevant Pages

  • Integration Services and ODBC
    ... I'm trying to build SSIS package that outputs data via ODBC. ... Create connection in Visual Stidio connection manager - when I try to ... how do I build SSIS package to connect to ODBC source? ...
    (microsoft.public.sqlserver.connect)
  • ssis package fails when run under sql server agent
    ... 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. ... same domain and the folder in question has ntfs security permissions set to ...
    (microsoft.public.sqlserver)
  • Data Download via ODBC
    ... and execute it, everything runs fine and it gets the data. ... Microsoft OLE DB Provider for ODBC Drivers ... error -2147467259 seems to indicate a problem with the ODBC driver. ... a SQL server agent job. ...
    (microsoft.public.sqlserver.odbc)
  • 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)