ssis - the '.' character hexadecimal value 0x00 cannot be included in a name -
while running ssis package xml source , sql server destination, getting error.please find attached error screen , kindly me....
many thanks, sreekanth
ascii null/nul regarded string termination character in host of languages. believe observing ssis libraries reading in source xml , presence of string termination signals read operation stop.
how can resolve it? quick way verify use hex editor edit source xml file , strip out nul values. if etl runs fine, either need source system not put in there. option see whether cdata tag allow safely escaped. think that's it's for. barring either of working, i'd resort running preprocessing step strip \0 character out of source file.
Comments
Post a Comment