It looks like a bug. What version are you using?

http://support.microsoft.com/kb/937969

Use the ...

print @cmd

instead of the exec to see what the query looks like. It looks like you have the single quotes off in the isnull section of the...

SELECT * FROM msdb.dbo.sysmail_allitems

WHERE sent_status = 'failed'

The default directory is C:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT

I had this problem when I reinstalled sql server on a different drive. Check your SQLAGENT.OUT log file and see if you have any errors starting any of the subsystems.

http://support.microsoft.com/kb/914171

Try this...

SELECT A.*

FROM (

SELECT derivedtbl_1.DAY,

...

It depends on your source. If you import from a file you can use something like...

INSERT INTO InventoryFeeds (InventoryXML)

SELECT InventoryXML

FROM ( SELECT * FROM OPENROWSET...

DECLARE @Collation VARCHAR (100)

Since the copy is not working from the article, I am posting it here. Maybe everyone will have better luck with this one.

--Query 1

DECLARE @Collation varchar(100)

DECLARE @sql VARCHAR(2000)

CREATE TABLE...

It looks like the formatting gets messed up when you cut and paste. This is what I got when I cut and pasted.

INSERT into ##TempSyncEXEC sp_msforeachdb @sql...

If you change the results to text you will not get ther error.

Depending on what you are doing you may be able to store the results in a temp table...

There is a connectionstring property you can set for your datasources in SSIS. You can use a variable in the expression builder for the connectionstring property.

You can get the number of spaces by...

Len(actorname) - Len(replace(actorname,' ',''))

If you are just looking for the last name in a three part name you can use the Reverse...