From which system table can I get the .dtsx thats actual XML code of any package deployed to SSIS Intergration services catalog.
Already checked in following tables
select Package_data from Internal.packages But it has null for all rows. ours is peoject based deployment.
Refer the solution provided in this link
In SSISDB you need to get package details as below
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Wednesday, April 16, 2014 4:29 PM
I am referring to SSISDB, MSDB hold the package if I deploy in MSDB.
@Navin, you marked the reply from Elvis as abusive unjustly. I will monitor how you on the forum.
@Elvis, I needed to delete your post because neither Joost not I could clear the abuse flag otherwise.
Arthur My Blog