Home Forums Data Warehousing Integration Services can not run SSIS package with script task when deployed to SQL Server under MSDB RE: can not run SSIS package with script task when deployed to SQL Server under MSDB

  • Hi,

    I am getting the following Error.

    Error: To run a SSIS package outside of SQL Server Data Tools you must install Sort of Integration Services or higher.

    I Created package1 with Execute Package Task and Another Package2 with Data flow Task and Sort Task in it.

    The Execute Package task calls Packge2.

    I ran into above error. If I execute Package2, then its works fine. But when i execute package1 it gives above error.

    Solution: In Execute Package Task, in package window, ExecuteOutOfProcess should be false. if i make it true then i get the error.

    Not Sure if this is going to help, but just wanted to share if it helps.

    Thanks