david.hao 17731 (11/26/2013)

---

Thanks, Phil.

The previous load is using XML Source in SSIS and there seems no problem. I queried the loaded data and did find invalid characters like "&"...

Me too.

Seems like a neater solution all round. Are you sure that this is not a possibility?

It sounds like a data error - as if the XML file is not well formed.

Do previous files still execute successfully? If so, that's almost certainly the problem.

What do you mean by this?

rarascon (11/22/2013)

---

Thanks, Phil! I remember something about SQL Search a while back, but haven't tried it yet. I'll check it out, and will give it a shot. =...

I'm...

My apologies, I misread the error.

Are you able to physically log in to the SQL Server server using the service...

The message:

gives you a fairly strong clue as to what the problem is, I think. This is not package-related, rather it relates to the SQL instance...

Try using a UNC path rather than a mapped drive.

miles_lesperance (11/19/2013)

---

I was able to work through the issue, and can now get all of the rows to be inserted. The file that I was trying to import did not...

Out of interest, can you briefly explain why you are using ADO rather than OLE DB?

Let you know ... what?

Can it be done? Yes.

Will we do it for you? No.

Will we help with questions? Yes - though you'll get better responses if you...

skosanabv (11/19/2013)

---

I found the solution

I experienced the same Issue with my packages, and tried all these solutions posted here, but none of them worked for me.

What I then did:

1. SQL...

Have a look here[/url] and see whether it helps.

If not, please explain a little about why you want to do this to give us some background.

No problem, thanks for posting back 🙂