Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. capitanosol

    SSIS Package information for documentation

    Hi, I am trying to extract some information from SSIS packages store on the server in [msdb].[dbo].[sysssispackages] For all packages, i need : PackageName All Sources information (Server, Databases, list of tables or views that are used in the source) All Transformations source table or...
  2. capitanosol

    Extracting the DataSource Property from DataTable in DSV

    Thanks for your response. Finally I had my solution. Not sure it's very clean but it work's fine for me. If someone have cleaner code it would be nice for the community. Here is what i did : Dim oServer As Microsoft.AnalysisServices.Server Dim DataSourceName As String...
  3. capitanosol

    Query SSIS XML Package to get Destination table names

    Hi, I already have this query that works fine to extract information from the package store on SSIS Server. ;WITH XMLNAMESPACES ('www.microsoft.com/SqlServer/Dts' AS pNS1, 'www.microsoft.com/SqlServer/Dts' AS DTS) -- declare XML namespaces SELECT c.name...
  4. capitanosol

    Extracting the DataSource Property from DataTable in DSV

    Hi, this is my first time here.... I have a written a small function in a SSIS Script task objet in order to extract some infomation about Cube that are on my server... I am almost done but I cannot extract the datasource from each table in a DSV starting from the cude. Some table in the same...

Part and Inventory Search

Back
Top