Integration Services error

  • I have created a new sql job and trying to run SSIS package as a daily schedule but when I try to save that SQL JOB I get following error.

    An exception occured while executing a Transact-SQL Statement of batch

    Microsoft.sqlServer.ConnectionInfo

    The specified @Subsystem is invalid ( valid values are returned by sp_enum_sqlagent_subsystems) Microsoft SQL Server, Error 14234

    Integration services are already installed on the server.

    Any help will be appreciated.

  • Looks like, I have RTM version of SQL Server. I need to install SP2 and then hopefully error will be fixed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply