XML Data source .. Expression? Variable? Connection? Error: unable toread the XML data -
02-23-2008
, 12:25 PM
RE: XML Data source .. Expression? Variable? Connection? Error: unable
to read the XML data.
I want my XML Data source to be an expression as i will be looping
through a directory of xml files.
I don't see the expression property or the connection property??
I tried setting the XMLData property to @[User::filename], but that
results in:
Information: 0x40043006 at Load XML Files, DTS.Pipeline: Prepare for
Execute phase is beginning.
Error: 0xC02090D0 at Load XML Files, XML Source [108]: The component
"XML Source" (108) was unable to read the XML data.
Error: 0xC0047019 at Load XML Files, DTS.Pipeline: component "XML
Source" (108) failed the prepare phase and returned error code
0xC02090D0.
Information: 0x4004300B at Load XML Files, DTS.Pipeline: "component
"OLE DB Destination" (341)" wrote 0 rows.
Task failed: Load XML Files
Information: 0xC002F30E at Bad, File System Task: File or directory "d:
\jcp\xmlLoad\jcp2.xml.bad" was deleted.
Warning: 0x80019002 at Package: The Execution method succeeded, but
the number of errors raised (2) reached the maximum allowed (1);
resulting in failure. This occurs when the number of errors reaches
the number specified in MaximumErrorCount. Change the
MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
The program '[3312] Package.dtsx: DTS' has exited with code 0 (0x0).
Thanks for any help or information. |