Post reply

How to see SSIS code from SQL Server?

  • May 5, 2011 at 5:12 am

    #239556

    Hi,

    I have SQL SSIS packages deployed in one of my production SQL Server. I can see the list when I connect to SQL Server Integration Service in SSMS. Now I want to see what code or logic is running in them to check which other servers, databases or table they are referring or using.

    I dont know there is any *.SLN available on the same server to open it from BI? is there any way to see code from SSMS or some other way..

    Please suggest.

    ~Satish

  • May 5, 2011 at 5:27 am

    #1320306

    Go to the Perticular package File and import it to some place and then You can open that dtsx file using BI and checkout your logic.

  • May 5, 2011 at 10:18 am

    #1320527

    Fabulous :-):smooooth:

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

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