I have run into a couple of situations where a cursor based solution was a lot faster than the set based solutions I was attempting, 45 minutes for the cursor...

Looks like you are trying to delete SQL Server system tables.  NOT a good idea.  What tables have you been able to delete so far?

I can't find xp_GetFileDetails on my SQL Server 2005 SP 2 system.

Looking at the July CTP:

xp_DirTree Yes

xp_SubDirs Yes

xp_FileExist Yes

xp_GetFileDetails No

I'll disagree with #4.  There are instances where cursors are usable.  Before using them, be sure you have looked at all other alternatives.

Try this:

SET @cmd = 'USE ' + @dbname + ';CREATE TABLE dbo.ETL_LAAD (LAAD_KEY bigint IDENTITY (1, 1) NOT NULL , LAAD_DATUM datetime NOT NULL) ON [PRIMARY]'

--EXEC @cmd

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