I got stumped with work, be back to you tomorrow:cool: or as soon as I can.

Ok, next thing then, is there a varchar(max)/nvarchar(max) (text_stream) or a float/real column in the dataflow?

😎

Now that...

Do replace char(13)+char(10) with '' ( empty string)

😎

Edit: character code.

Check line 4489 for an extra delimiter character

😎

A simple way would be along these lines

😎

USE tempdb;

GO

DECLARE @DSET TABLE

(

ClassName VARCHAR(50) NOT NULL

,NAV ...

autoexcrement (5/16/2014)

---

P.S. There is some added logic to do with whether subsequent sales are attempted by the original SalesRep or another SalesRep, but I'll leave that for later. Just wanted...

Suggest obtaining a 64bit Windows rather than a 32bit SQL 2014

😎

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...