July 20, 2022 at 4:47 pm
We have some data on a legacy system and have been transitioning away from it to a newer system.
I think we're done but but it would be nice to search all the SSIS source to be certain. The way I've normally done this is by just doing a file search of all the DTSX files in my source folder, but this isn't a complete list.
I would need to download every project from TFS and wondering if it's possible to search source on the SQL Server directly? Actually in the past I've not had luck searching TFS but now we keep everything in TFS Git repos so maybe that will work. Will try that as well.
All our packages are stored in the SSISDB database. I know they are encrypted but is it possible to decrypt and search the file contents?
July 20, 2022 at 5:00 pm
I've never tried, but do you have the password used when the SSISDB database was created? If you do, you could try the sort of stuff which is detailed here.
To be honest, you might be better off using SSMS to export the SSISDB projects to ispacs and then unpacking those. This method will definitely work.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 20, 2022 at 6:31 pm
Ok yeah I wasn't sure if it's as simple as just using the dmk. Read a post that made me think there was more going on with the encryption.
I'm going to give that a shot on my dev server and see what I get.
Otherwise I'll grab the source or the ispac files like you suggested.
Will reply if I find anything interesting.
Thx
July 21, 2022 at 7:31 am
Ok yeah I wasn't sure if it's as simple as just using the dmk. Read a post that made me think there was more going on with the encryption.
I also seem to remember reading this somewhere. Worth a try nonetheless. You could also try running a trace while exporting an ispac to see whether that provides any clues.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply