Share via

How to get SSIS package source details

Bala Narasimha Challa 466 Reputation points
2022-06-14T07:28:30.397+00:00

Hi Team,

In my project 100 of SSIS packages deployed in SSMS and for few packages excel or flat file is source.

I need SSIS packages details where its connected excel or flat file source.

Thanks in advance

SQL Server Integration Services
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,536 Reputation points
    2022-06-14T07:37:11.79+00:00

    Hi @Bala Narasimha Challa ,

    You may right click the project and choose validate in the in SSISDB.

    And then click Connection Manager to see the source type of the packages.

    211177-image.png

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.