SSIS XML Configuration - All properties are disabled

Avik Mukherjee 1 Reputation point
2023-03-09T13:29:53.3966667+00:00

Hi there,

I am using SQL Server 2019 and after many years I am trying to use SSIS and therefore not sure if I forgot something or there is something really weird?

I selected XML config and here I am unable to select any checkbox.. all disabled, no mouse click selecting anything.

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,941 Reputation points
    2023-03-09T16:07:22.4866667+00:00

    Hi @Avik Mukherjee,

    SSIS XML Configuration option is kept for backward compatibility with the obsolete SSIS 2005-2008R2 versions.

    Starting from SSIS 2012 onwards, it is using Integration Services Catalog and SSISDB database. As end result, there is no need anymore to use XML file configuration.

    Modern SSIS is using project level Parameters and Connections for Configuration. If needed, you could also use SSIS Environments.

    ssis-database-and-catalog

    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 32,506 Reputation points
    2023-03-10T02:52:27.62+00:00

    Hi @Avik Mukherjee,

    I could use XML Configuration with the property successfully, please make a double check.

    User's image

    Here is a detailed tutorial, you may take a reference to.

    Regards,

    Zoe Hui


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

    0 comments No comments