jasona.work (6/18/2014)

---

That explains the deja-vu when I saw the same person walk...

It was a glitch in the matrix, Neo.

John Mitchell-245523 (6/18/2014)

---

BWFC (6/18/2014)

---

I disagree there. It doesn't say that all on site databases are 2012, it says that uses 2012. That doesn't preclude there...

Could you give an example of what is different?

The best function there is to find:

Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

There must be one gazillion hits on Google for "sql server backup restore".

This is one of them:

Create a Full Database Backup (SQL Server)

If the source - for whatever reason - thinks the columns are unicode and the destination is non-unicode, you'll have to do a conversion.

Either in the source query (which seems...

Ryan1 (6/18/2014)

---

I figured as much, but how does one...

Maybe the error is different on other machines?

With Excel and JET OLE DB, 32-bit is usually the key. If SSMS is 64-bit, that could likely cause an issue.

Sean Pearce (6/18/2014)

---

I found the question good and I had no problem understanding the author's intent.

There are only two valid answers, Azure and 2000. Being told the company only uses...

The only way to know for sure if it works is to try it out.

Personally, if the field is too large for an ordinay nvarchar, I'd do the comparison in...

You'll need to open each package and look at the configuration properties.

Or learn how to parse the XML behind the SSIS packages for a certain value.

The JET OLE DB provider may not be present by default on any machine, so it's possible you need to install it.

GilaMonster (6/18/2014)

---

Except...

EdVassie (6/18/2014)

---

Sorry, I should have said the install will fail if the account running the install and the machine name (not the domain name) are the same.

I have not been...