The XML source does not validate the data in the XML file against the XSD

Important to know:

The SSIS "XML source" element check validation of the input XML file,

but – check only the structure, not the data!

That mean not valid data will pass this validation check!

Is it good or not?

Depend on the case.

But don't forget it…

https://docs.microsoft.com/en-us/sql/integration-services/data-flow/xml-source

Get plans of a Stored Procedure

Select  PS.total_logical_reads/NullIf(DateDiff(Minute,PS.cached_time,GetDate()),0) N,

        Coalesce(DB_Name(PS.database_id),DB_Name(PSh.dbid),DB_Name(PSph.dbid))

        DBName,

        Object_Schema_Name(Coalesce(PS.object_id,PSh.objectid,PSph.objectid),Coalesce(PS.database_id,PSh.dbid,PSph.dbid))

        SchemaName,

        Coalesce(Object_Name(PS.object_id,PS.database_id),Object_Name(PSh.objectid,PSh.dbid),Object_Name(PSph.objectid,PSph.dbid))

        ObjectName,

        PS.*,

        PSh.text,

        PSph.query_plan

From    (Select Object_Name(object_id), *

        From    sys.dm_exec_procedure_stats (NoLock)

        Where   database_id=DB_ID('DatabaseName')

                And Object_Schema_Name(object_id)='SchemaName'

                And Object_Name(object_id)='SpName'

        Order By total_logical_reads/NullIf(DateDiff(Minute,cached_time,GetDate()),0) Desc) PS

Outer Apply sys.dm_exec_sql_text(PS.sql_handle) PSh

Outer Apply sys.dm_exec_query_plan(PS.plan_handle) PSph;