Sunday 16 April 2017

Executables table in SSISDB

This package store the information of package name, package full path, package location type, package path and executable package name.
SELECT [executable_id]
      ,[project_id]
      ,[project_version_lsn]
      ,[package_name]
      ,[package_location_type]
      ,[package_path_full]
      ,[executable_name]
      ,[executable_guid]
      ,[package_path]
  FROM [SSISDB].[internal].[executables]



No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts