January 13, 2017 at 8:32 am
Hi
I have a SSIS project that has around 30 packages
Is there an easy way to search though all the packages to find where a specific table or column or ... has been referenced?
Thanks
Damian.
- Damian
January 13, 2017 at 8:37 am
DamianC - Friday, January 13, 2017 8:32 AMHiI have a SSIS project that has around 30 packages
Is there an easy way to search though all the packages to find where a specific table or column or ... has been referenced?Thanks
Damian.
Do a search in the file system using something like FileSeek.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 13, 2017 at 8:45 am
Thanks Phil, I'll take a look
Appreciate it's in XML
Wasn't sure whether I could do something in T-SQL
- Damian
January 13, 2017 at 9:42 am
DamianC - Friday, January 13, 2017 8:45 AMThanks Phil, I'll take a look
Appreciate it's in XML
Wasn't sure whether I could do something in T-SQL
Assuming your packages are deployed to SSISDB, you can't do much in T-SQL because they are held in an encrypted form.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 18, 2017 at 6:13 am
If you can open the solution in Visual studio editor (SSDT) and right click the package name in the solution explorer, then click View Code, it gives you the xml code for the package.
Now you can search inside this code using the usual Ctrl+F.
For multiple packages,you'll need to select all packages and do the same as above. Only this time you can use "search in all open documents" instead of "current document"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply