hardikr (11/28/2013)

---

Thanks for reply.

yes, Path and file both are exists when package runs.

OS installed on server is Windows Server 2008 R2.

My package runs under user SQLServices and I have...

hardikr (11/28/2013)

---

I am having the opposite issue. I am trying to execute SSIS package using xp_cmdshell.

Can anyone please help me?

I have created SSIS package which exports data into excel file....

Remove the line

Private Const Location As String = "User::VarLocation" // declared as variable

And then ...

Dim var1 As String = DirectCast(Location, String)

should become something like

Dim var1 As String = Dts.Variables("Location").Value

I...

I can't think of a neat and tidy way of doing this without scripting. But with a script task, not difficult at all.

Koen Verbeeck (11/27/2013)

---

Phil Parkin (11/27/2013)

---

You should bear in mind what the...

You should bear in mind what the packages are doing when...

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.