Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need scirpt to SSIS package datasource details. Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 4:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 2:49 AM
Points: 5, Visits: 52
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
Post #1509255
Posted Tuesday, October 29, 2013 4:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:20 AM
Points: 13,717, Visits: 10,667
This could be a good start:
Collecting information about your SSIS packages




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1509258
Posted Wednesday, October 30, 2013 12:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 2:49 AM
Points: 5, Visits: 52
Am able to get the script for getting package names but am not able to get database info, connection string and users details.
Post #1509661
Posted Wednesday, October 30, 2013 1:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:22 AM
Points: 5,073, Visits: 11,849
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?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1509666
Posted Wednesday, October 30, 2013 1:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:20 AM
Points: 13,717, Visits: 10,667
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1509673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse