I'm trying to create a xml import SSIS job. I can open the xml and generate
the .xsd which will validate to the original xml in an xml editor like Oxygen
so the xml does seem to be well formed.

The problem seems to be that SSIS does not allow the normally allowed
character of "." in element names <XC10.BU.AFFILS></XC.BU.AFFILS> won't
work.

I get an error
Error at Data Flow Task [DTS.Pipeline]: The object name "XC10.BU.AFFILS" is
not valid. The name cannot contain any of the following characters: /\:[].=

All of these sort of make sense except for "." That is used somewhat
routinely I think. I couldn't find anything in the xml w3 docs that say you
can't use the period or anywhere else on the web.

Any ideas of how to get around this without changing the xml?

Thanks,
Forrest