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

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