Try using

SET SHOWPLAN_XML ON;

to get the execution plan, could be a parsing error when displaying the plan.

😎

Looks like you have a 32bit version of Windows 8.1.

😎

Quick test for the version

USE tempdb;

GO

SELECT @@VERSION;

😎

ringovski (5/16/2014)

---

Apparently I need to be using Business Intelligence Development Studio which is a separate optional install in the SQL server install. Can anyone confirm that this is correct? getting...

Quick question, what are you seeing in sys.database_files?

😎

select * from [database name].sys.database_files

KoldCoffee (5/17/2014)

---

So, are you saying that I need to first move the zip file to a second folder to isolate it, before unzipping and moving it's contents to a third...

Most likely (almost certainly!) this query produces a plan with two scans and a nested loop. For each row in the outer (Customers) it scans the inner part, something like...

Could be a case of missing schema qualified reference. Don't rely on the default schema and add the schema name to the table name in the query.

Technically, there is nothing...

Simple solution, use the ForEach File to move the files to an "unzip" directory and unzip from there to the Fileprocess directory.

😎

This article might help

Configuring the Integration Services Service (SSIS Service)

😎

mister.magoo (5/17/2014)

---

I forgot to mention that you cannot have an xml version declaration in an XML datatype in SQL Server, so once you have the xml how you want it,...

For this I use either vi/vim...

A hunch, if the catalogs are set to "do not track changes", I believe the upgrade will not rebuild them.

Whether you HAVE to, I don't know, last time I upgraded...

A quick thought, build an alter catalog sql string and run in each db?

😎

SELECT

CONCAT('ALTER FULLTEXT CATALOG ',FTC.name,' REBUILD;')

FROM sys.fulltext_catalogs FTC

You might want to correct the problem at schema...