Hi I have the following code and I get an error.

Propably syntax but I m new to DTS

sql = "UPDATE Weeks SET WeekStart = '"& ww &"' FROM CurrentWeek
WHERE Weeks.WkNo = CurrentWeek.Wkno + 1"


ww is a global variable

Can anyone help?

Thanks in advance

RIRI

And you have this code where?

Yep this will fail no matter where you are in DTS.

Have a look at

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Or (Page 8)

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)



"eleftheriak (AT) hotmail (DOT) com" <eleftheriak (AT) hotmail (DOT) com> wrote