What error are you getting?

The script is a straight copy from one that is in use on our servers. 

Alternatively you could use a scripting task and the FSO to avoid using xp_cmdshell

Dim oFSO

This is our server at work (Twin 1.2Mhz PIII's & 1Gb Ram)

--===== Frank's function

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If DBCC...

At least until version 11 (1,000,000 rows)

Have a look here to start

http://www.sqldts.com/default.aspx?225

It's ok as long as they don't start arguing.  Then it gets too loud.

Are you using a Script Component in SSIS?

You could try using the ForEach component and set it to look for the part of the filename that does not change.

The article is printed in one of the fullstops via microfilm (lol)

Fortunately I am the only DBA here so what I say goes!! (As long as I listen to myself )

OOps just been told...

Ad the server is local, have you tried rebooting the machine?

Can you connect to the server using its IP address?

Can you ping and tracert to the server via its name?

I had this problem and "fixed" it my adding an entry...

Users altering tables

Are the quotes around each field?  If so it could be set to quote text.

How about something like:

DECLARE @Order string

DECLARE @sql string

SET @sql = "SELECT * FROM Blah "

SET @Order = CASE WHEN

@orderId = 1 then "title asc"

when @orderId = 2 then "title...

Watch out for chapter 6 (Evaluate SQL Task).  Don't spend time trying to figure out the problem, go to their web site and forum.