sql - Multiple XML sources to OLE DB in SSIS -

sql - Multiple XML sources to OLE DB in SSIS -

i have bunch of different xml souces (over 100), , trying pipe them ole db via ssis. started out trying utilize union function, since not of info goes each row of database of same type, of values entered in "ignore" ssis, , come out null. each xml source has multiple outputs well, trying avoid manually pointing each node of each xml source @ different db source, , combining them. know can alter input type of info in xml source under advanced options, there doesn't appear way default 1 info type (string work me). there way utilize union feature work me, or improve way this? in advance.

does server have access folder contains xml files? if does, using ssis not nesessary. utilize openrowset can create stored procedure selects info xml sources , union results. sp can utilize in ssis package.

sql sql-server xml ssis