sql server - XML Sources Randomly Fail on Execution in SSIS -

sql server - XML Sources Randomly Fail on Execution in SSIS -

in ssis, have script task pulls info , creates , bunch of xml documents. have documents read in xml source tasks, , go ole db. each time run entire package, 1 or 2 of xml source tasks fail. failing xml source task appears random @ first glance. without changing @ all, if run bundle again, different xml source task fail, or may run of them successfully. running 3rd time produces new failures or success, , on. seems regenerating xsds xml source fails temporarily fixes task, fails 1 time again after number of runs. same error on given xml source task, looks this:

http://i.imgur.com/0ghklbb.png

i have no thought causing new ssis, help much appreciated. thanks.

will possible in task script output xml document of info type dt_iu4 or dt_str( rather xml type). check what's info type of wsoperationmetrics in xsd, seek map it's output info type accordingly.

have of thread.

sql-server xml ssis