XML Task fails to validate multiple files in SSIS 2005

Question

0.00/5 (No votes)

See more:

Hi,

I am having a for each loop to loop through all the files, child component is XML Task, in XML task XML file is validated using XSD.

The problem I face is -

after getting one failed file, it fails to validate all the other file and moves to error folder.

Eg - I have file as follows -

Success1.XML
Failed1.XML
Success2.XML

In this case Success1.XML gets validated successfully and moves to respective success folder,
Failed1.XML gets validated and since its failed file it moves to failed folder,
But as Success2.XML has valid records it should move to success folder after validating but it moves to failed folder on validation.

If I re-run the package with Success2.XML file alone it gets successfully validated and moves to respective success folder

Please help I am struggling with this issue since 4 days.

Please its very very urgent

Thanks,
Chirag

Posted 10-Jun-14 8:54am

Chirag Shah.Gogari

Updated 10-Jun-14 23:53pm

v2

Add a Solution

Comments

karthik Udhayakumar 10-Jun-14 21:11pm

Chirag,Dont you think you need to paste your code ?For getting answers

Chirag Shah.Gogari 11-Jun-14 5:52am

Hi Karthy, Its tools and properties set to it, I cannot paste code

Dinesh.V.Kumar 12-Jun-14 1:32am

Is there any error that is thrown?Could you please check that and let me know so that we can narrow down the issue.

Regards,
Dinesh Kumar.V.

Dinesh.V.Kumar 12-Jun-14 1:35am

Try troubleshooting by following some of the steps mentioned in this link given below
http://msdn.microsoft.com/en-IN/library/ms137625.aspx

Regards,
Dinesh Kumar.V.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Chirag Shah.Gogari · Answer 1 · 2014-06-11T23:22:00

Hi,

Thanks for your reply. From the investigation I found it will not work in XML Task, for the above scenario we need to add validations in Script Task.

Dinesh,
There was also no as such error message thrown, so it was very difficult to trace the issue.

Thanks all thanks for response

Thanks,
Chirag