I also need to output as XML Raw.

Thank you for the responses.

Thanks for the input.

Hi to you. :hehe:

Thanks for the advice.

There is not an SP involved.

It is a Bulk Insert in an SSIS Package.

Thanks again.

Nadrek (2/12/2014)

---

Welsh Corgi (2/12/2014)

---

Nadrek (2/12/2014)

---

Upgrading hundreds of import/export packages to a new version...

What?...

Nadrek (2/12/2014)

---

Bah; no need for a wizard for a few hundred rows on a one-off import when a simple EXCEL formula creates your INSERT statements for you.

=CONCATENATE("INSERT INTO #YourTable VALUES...

You could create a Linked Server for one but I would import the Data into SQL Server Tables.

You can use the Import Wizard which is basically SSIS.

You may need to...

Problem went away.

It was the firewall.

It is working.

I got it, just simply add another line with the logical and physical file name.

Revenant (1/23/2014)

---

Welsh Corgi (1/23/2014)

---

Revenant,

I will get a statement from the Microsoft SQL Server Engineer that documents what actions were taken and the outcome?

The situation was not the norm and there...

Lynn Pettis (1/18/2014)

---

Welsh Corgi (1/18/2014)

---

Lynn Pettis (1/18/2014)

---

Welsh Corgi (1/18/2014)

---

Lynn,

I had to drop the database and restore. Basic syntax.

I think the problem was that they did not stop the SQL Server...

Revenant,

I will get a statement from the Microsoft SQL Server Engineer that documents what actions were taken and the outcome?

The situation was not the norm and there were extenuating circumstances.

What...