Msg 15281, Level 16, State 1, Line 16
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', search for 'Ad Hoc Distributed Queries' in SQL Server Books Online.

Subcomponent: OLE DB Source [14], Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Не удалось определить метаданные, поскольку инструкция "EXEC (''CREATE SYNONYM [dbo].[''+@ObjName+''] FOR [''+@SchemaName+''].['' +@ObjName+'']'')" в процедуре "CreateSynonym" содержит динамический код SQL. Рекомендуется использовать предложение WITH RESULT SETS, чтобы явно описать результирующий набор.".


SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "The metadata could not be determined because statement 'EXEC ('CREATE SYNONYM [dbo].['+@ObjName+'] FOR ['+@SchemaName+'].[' +@ObjName+']')' in procedure 'CreateSynonym' contains dynamic SQL. Consider using the WITH RESULT SETS clause to explicitly describe the result set.".

<ns:TSQLQueryCollector xmlns:ns="DataCollectorType"><Query><Value>
DECLARE @dbsize bigint 
DECLARE @logsize bigint 
DECLARE @ftsize bigint 
DECLARE @reservedpages bigint 
DECLARE @pages bigint 
DECLARE @usedpages bigint

SELECT @dbsize = SUM(convert(bigint,case when type = 0 then size else 0 end)) 
      ,@logsize = SUM(convert(bigint,case when type = 1 then size else 0 end)) 
      ,@ftsize = SUM(convert(bigint,case when type = 4 then size else 0 end)) 
FROM sys.database_files

DECLARE @allocateUnits table( 
        total_pages bigint
,       used_pages bigint
,       data_pages bigint
,       container_id bigint
,       type tinyint
); 

INSERT @allocateUnits SELECT total_pages, used_pages, data_pages, container_id, type FROM sys.allocation_units;

SELECT @reservedpages = SUM(a.total_pages) 
       ,@usedpages = SUM(a.used_pages) 
       ,@pages = SUM(CASE 
                        WHEN it.internal_type IN (202,204) THEN 0 
                        WHEN a.type != 1 THEN a.used_pages 
                        WHEN p.index_id &lt; 2 THEN a.data_pages 
                        ELSE 0 
                     END) 
FROM sys.partitions p  
JOIN @allocateUnits a ON p.partition_id = a.container_id 
LEFT JOIN sys.internal_tables it ON p.object_id = it.object_id 

SELECT 
        @dbsize as 'dbsize',
        @logsize as 'logsize',
        @ftsize as 'ftsize',
        @reservedpages as 'reservedpages',
        @usedpages as 'usedpages',
        @pages as 'pages'
</Value><OutputTable>disk_usage</OutputTable></Query><Databases UseSystemDatabases="true" UseUserDatabases="true" /></ns:TSQLQueryCollector>

сообщение: 11514, уровень: 16, состояние: 1, процедура: sp_describe_first_result_set, строка: 1 [строка начала пакета: 0]
Не удалось определить метаданные, поскольку инструкция "EXEC ('CREATE SYNONYM [dbo].['+@ObjName+'] FOR ['+@SchemaName+'].[' +@ObjName+']')" в процедуре "CreateSynonym" содержит динамический код SQL.  Рекомендуется использовать предложение WITH RESULT SETS, чтобы явно описать результирующий набор.