dbTalk Databases Forums  

XML Data source .. Expression? Variable? Connection? Error: unable toread the XML data

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss XML Data source .. Expression? Variable? Connection? Error: unable toread the XML data in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
wildman@noclient.net
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.