January 20, 2017 at 7:09 am
Microsoft has a wonderful (I assume) proc for pulling connection strings from the XML of an SSIS package. All one needs to do is supply the SSIS package path and run the proc. The problem is, I can't figure out how to get the location of my SSIS packages.
Yes, I've looked in msdb.dbo.sysssispackages and msdb.dbo.sysssispackagefolders. I've tried using the Folder name in the later for the proc, it doesn't work. I've tried using "\MSDB\FolderName", it doesn't work. This is the error I keep getting.
Operating system error code 3(The system cannot find the path specified.).
I want to search multiple packages without having to put in each one separately, but I will be happy if I can just figure out how to pull the path of just one. Any thoughts?
January 20, 2017 at 7:17 am
Brandie Tarvin - Friday, January 20, 2017 7:09 AMMicrosoft has a wonderful (I assume) proc for pulling connection strings from the XML of an SSIS package. All one needs to do is supply the SSIS package path and run the proc. The problem is, I can't figure out how to get the location of my SSIS packages.
Yes, I've looked in msdb.dbo.sysssispackages and msdb.dbo.sysssispackagefolders. I've tried using the Folder name in the later for the proc, it doesn't work. I've tried using "\MSDB\FolderName", it doesn't work. This is the error I keep getting.
Operating system error code 3(The system cannot find the path specified.).
I want to search multiple packages without having to put in each one separately, but I will be happy if I can just figure out how to pull the path of just one. Any thoughts?
Are they deployed to SSISDB?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
January 20, 2017 at 7:21 am
January 23, 2017 at 9:03 am
Okay, no one has replied. I'm going down a different path. Let me know if anyone has an answer to this, because I would love to find it.
BTW, the package source is "SQL Server" which, to my knowledge stores SSIS packages straight to MSDB.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply