October 29, 2013 at 4:30 am
Hello All,
I need SQL script to get SSIs package name, Connection Name,Database used and users.
To get the datasoure details.
Please let me know.
Thanks
October 29, 2013 at 4:34 am
This could be a good start:
Collecting information about your SSIS packages
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2013 at 12:08 am
Am able to get the script for getting package names but am not able to get database info, connection string and users details.
October 30, 2013 at 1:07 am
anjanbv (10/30/2013)
Am able to get the script for getting package names but am not able to get database info, connection string and users details.
When you say users details, do you mean the users of the package? If so, you are out of luck - this is not stored in the package.
Whether you can easily get the connection info depends on how the connections have been set up. Are they coded directly in the package, or are they inherited from a project?
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
October 30, 2013 at 1:54 am
Phil Parkin (10/30/2013)
anjanbv (10/30/2013)
Am able to get the script for getting package names but am not able to get database info, connection string and users details.When you say users details, do you mean the users of the package? If so, you are out of luck - this is not stored in the package.
Whether you can easily get the connection info depends on how the connections have been set up. Are they coded directly in the package, or are they inherited from a project?
Also check the protection level of the package, that info might be encrypted.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply