How to see SSIS code from SQL Server?

• Satish-1028188

  Mr or Mrs. 500

  Points: 588

  More actions

  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

• sharath.chalamgari

  SSCertifiable

  Points: 5680

  More actions

  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.

• Satish-1028188

  Mr or Mrs. 500

  Points: 588

  More actions

  May 5, 2011 at 10:18 am

  #1320527

  Fabulous :-):smooooth: