Any Idea about below Error?

Question

1.00/5 (2 votes)

See more:

I am getting below xml file while I am generating xml file from Execute Sql Task. Please help me out

XML

<?xml version= "1.0" encoding="utf-8" ?><ROOT><?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="No description provided"?></ROOT>

Posted 10-Dec-13 1:41am

coded007

Add a Solution

2 solutions

Solution 1

Hi,

Have you tried this error in google ? I am not having much idea but you must be doing it wrong way.

I found some links for the similar error.

http://www.sqlservercentral.com/Forums/Topic953354-148-1.aspx[^]

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/61570215-63d6-42e3-84ef-54f6413cbf91/how-can-i-generate-a-huge-xml-from-ssis?forum=sqlintegrationservices[^]

[Edit] One more link : it looks this guy resolve the issue
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157817[^]
[/Edit]
Check if it helps you.

Best luck

Posted 10-Dec-13 1:47am

AmitGajjar

Updated 10-Dec-13 1:49am

v2

Comments

coded007 10-Dec-13 7:57am

Thanks Amit for your response. Nothing is working for me most one important thing is i need to maintain connection in OLEDB only

AmitGajjar 10-Dec-13 7:59am

can you provide your steps of creating SSIS job ?

coded007 10-Dec-13 10:07am

Two arrays of data and For each loop with in For each loop. In second for each loop i have execute sql task give this error.

AmitGajjar 12-Dec-13 23:45pm

try to execute your sql task individually. i believe there is some issue with your sql task.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

coded007 · Accepted Answer · 2013-12-11T01:28:00

Solution 2

My Stored Procedure is returning XML data type and I am storing it in String. So, error comes into picture.

Posted 11-Dec-13 1:28am

coded007

Comments

AmitGajjar 12-Dec-13 23:46pm

great to see you resolve your query.

Any Idea about below Error?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Any Idea about below Error?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us