It would probably help more if you explained what it is you are try to accomplish besides just modifying the code.  An example of the expected output would also help.

What exactly are you trying change in OLE DB source?

update dbo.TargetTable set

     targetfield = dateadd(yyyy, targetfield, 1)

where

    (any criteria to restrict the update)

Have you also included the size of the indexes in your calculations?

Here is the problem (only thing I can think of why it worked on my system is I am running on SQL Server 2005):

WHERE

    (class.class_date > GETDATE()) AND (course.course_type_id =...

Here is my suggestion, contact Microsoft.  With the configuration you listed, you may be able use the Developer Edition for your Development, QA, and Training servers, and then use the...

True, I goofed with the THEN, I sometimes put it in as a line comment to keep things straight in my mind.

Just for me, can you post back what you copied?  Thanks.

Check out John's code, I think it will do what you need also (I haven't tried myself).  Also, as you didn't post the code you are running based on my...

Looking at your code, not even going to try and fix it.  You are using CASE incorrectly to start.  From your description of the problem, your script (or stored procedure)...

Start by reading about configuration files in BOL.  You can also learn more in the WROX book Professional SQL Server 2005 Integration Services by Brian Knight, et al.

Try this:

SELECT

    dtclass.class_id,

    dtclass.class_date,

    course.course_type_id,

    location.location_id,

    location.display_city,

    location.location_city

FROM

   (select

        class.class_id,

        class.class_date,

        class.course_type_id,

        class.location_id

    from

        dbo.class

    where

        class.class_id in (select top 1 sq.class_id from dbo.class sq where class.course_type_id = sq.course_type_id and...

Sounds like a scheduled job to me.  Yes, you can.

I am still not sure what your procedure is supposed to do.  What is the input and what is the expected (not actual) output from the procedure?

Brandie,

Actually, I haven't purchased any of the "test help" books.  I have quite a few of the MS Press books related to SQL Server 2005 which I rely on, but...