XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data in SSIS

[wil...@noclient.net]

RE: XML Data source .. Expression? Variable? Connection? Error: unable
to read the XML data in SSIS

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.

[ML]

Could there be something wrong with the source file?
How are you setting the value of the variable containing the file name of
the source file?

In the XML Data Source make sure in the Connection Manager group the
properties are set correctly:
1) Data access mode: "XML file from variable";
2) Variable name: path/name pointing to the source file;
3) Use inline schema or path/name of a XML schema for the source file.

In case you're using a Foreach Loop Container (e.g. with the Foreach File
Enumerator) to traverse a collection of source files and moving files from
the source folder after they have been processed then make sure that the
variable's default setting is pointing to a file that is never processed
(i.e. moved), in order to have an appropriate source file always accessible
for package validation.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

[wil...@noclient.net]

I found the issue. there is an option in xml datasource specifying
that the file source will be a variable. Once I set that the xml was
read and processed.

Thanks.