Run SSIS package through Server its working fine but that package I am running on my local system its not working.

Jerry_2424 0 Reputation points
2024-03-06T11:49:24.4166667+00:00

I am using 2016 SSMS client on my local system [SSMS-Setup-ENU.exe] .

I am using 2017 visual studio.

I created a package on Visual Studio 2017 , this package is based on package deployment model, I'm running this package through powershell and call the execute package utility it present in this location "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn" It's Working .

But I'm using my existing package who build in visual studio 2017(2 years ago) it was run on server properly but it is not running on my local system
I'm using Execute package utility to run this package it gives me a error

Error Code :- 0xC000F427

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

I do no why its giving me a error I am searching every where no one can giving me the answer no other website posted this answer.

After that I was installed ssms 2022 [SQL2022-SSEI-Dev.exe] and I am doing a setup by my own

my packages was worked properly and run by Execute package utility also .

Now I have a doubt in ssms 2016 ,

I have created my own package it was works properly on my system but why not existing package will work ?
In this particular situation Execute package utility will not worked for both the packages but why its works for one and not for another one?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,641 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,354 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,656 Reputation points
    2024-03-06T11:55:13.69+00:00

    To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.

    As the message clearly says, you need a running (installed) SSIS on the machine.


  2. ZoeHui-MSFT 32,426 Reputation points
    2024-03-07T03:16:42.8033333+00:00

    Hi @Jerry_2424,

    As the error message said, you need to install SSIS on your machine.

    To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.

    If the target sql server version of you package is SQL 2017, you may need to run the utility use the SQL 2017 version and has the ssis2017 installed on the machine.

    When you use the current version of the dtexec utility to run a package created by an earlier version of Integration Services, the utility temporarily upgrades the package to the current package format.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.