Error using Database Engine Tuning Advisor 1

[hedgracer]

I am trying to use Database Engine Tuning Advisor for the first time. I am using it on a script file. The script file is on my C: drive and is named tempquery.sql and has the following in it:

DECLARE @dt VARCHAR(50);
SET @dt = '20100604';


UPDATE [Moneyline_One]
SET [Moneyline_One].Reg = CURRENTMAP.REG,
[Moneyline_One].Dept = CURRENTMAP.DEPT
FROM CURRENTMAP, [Moneyline_One]
WHERE [Moneyline_One].Reg Is Null
AND [Moneyline_One].Date_Upload = @dt
AND CURRENTMAP.SALESMAN = [Moneyline_One].Sales_Series
AND CURRENTMAP.OFFICE = [Moneyline_One].Office
AND CURRENTMAP.FIRM = [Moneyline_One].Firm;

When I run Start Analysis the process gets to Consuming Workload and generates the following error message:

All the events in the workload were ignored due to syntax errors. The most common reason for this error is that the database to connect has not been set up correctly.

What exactly does this error mean? I have ran this script file and it works perfectly. Thanks for all help in advance.

Dave

 

[Crowley16]

have you tried putting a using <myDb> clause at the top of your script?

--------------------
Procrastinate Now!