none
SubSytem could not be loaded RRS feed

  • Question

  • Hi,

    I'm running SQL Server Agent services and SQL Server Integration services under same Domain\User account which is also added in windows administrator groups and the same Domain\User account is also having sysadmin rights in sql server.

    And below is the SQLAgent.OUT file details which I'm getting while running the SSIS from SQL Agent job.

     [100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 4012
     [101] SQL Server MachineNameXYZ version 9.00.1399 (0 connection limit)
     [102] SQL Server ODBC driver version 9.00.1399
     [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
     [310] 4 processor(s) and 3072 MB RAM detected
     [339] Local computer is MachineNameXYZ running Windows NT 5.2 (3790) Service Pack 1
     [432] There are 11 subsystems in the subsystems cache
     [125] Subsystem 'ActiveScripting' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'CmdExec' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'Snapshot' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'LogReader' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'Distribution' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'Merge' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'QueueReader' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'ANALYSISQUERY' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'ANALYSISCOMMAND' could not be loaded (reason: The specified module could not be found)
     [125] Subsystem 'SSIS' could not be loaded (reason: The specified module could not be found)
     [364] The Messenger service has not been started - NetSend notifications will not be sent
     [129] SQLSERVERAGENT starting under Windows NT service control
     [260] Unable to start mail session (reason: No mail profile defined)
     [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
     [LOG] Step 1 of job 'TestJob' (0x4A197E88EAD5134581A35132A546414C) cannot be run because the SSIS subsystem failed to load.  The job has been suspended
     [LOG] Unable to read local eventlog (reason: The parameter is incorrect)
     [LOG] Unable to read local eventlog (reason: The parameter is incorrect)
     [LOG] Step 1 of job 'TestJob' (0xE412C2AB10C7A34B87F5DFC8CFD978CA) cannot be run because the SSIS subsystem failed to load.  The job has been suspended
     [LOG] Unable to read local eventlog (reason: The parameter is incorrect)

    Any help will be appreciated.

    Regards,

    M.S

    Tuesday, July 4, 2006 7:29 AM

Answers

All replies