Set a breakpoint on the execute SQL task on before execute, then set a watch on the Period variable to see if it's getting populated correctly and step through.

http://lmgtfy.com/?q=sql+2005+performance+and+optimisation+tips

That sounds correct if you have 3 files that are failing?

Instead of using the OnError event to run a script task, can you use the failed precendence constraint on the...

Oh just noticed I gave you the wrong syntax for that first reply (DAY instead of d)

[SQL] SELECT * FROM tbl WHERE CONVERT(datetime, [myDateString], 103) > DATEADD(d, -3, getdate())

Painful dealing with dates stored as strings..

You'll have to use the same method as the YEAR query.

SELECT *

FROM tbl

WHERE CAST(SUBSTRING([myDateString], 1, 10) AS DATETIME) >= DATEADD(d, -3, getdate());

Are there multiple instances of SQL2005 installed on the box? (ie are you looking at the correct SQL Agent service?)

Open SQL Configuration Manager and check it there.

What's changed...

What are the errors?

With a lot of effort 😀

replace > with >

Looks like your date data is stored as a string instead of a date data type. Can you post up some of the date string values?

The...

Oh sorry, I didn't notice this was in the 2008 area of the forum, it works for 2012.

Ok, you could try exporting the registry key:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

Then importing that on...

Do you *really* need to join that many tables? Ie. are you developing an application that displays this information all at once, on one screen, with bits of...

It would depend on the application using the connection string. The SQL engine doesn't care what method of authentication is used, as long as the user is authenticated. ...

You need a tab delimited file for excel to recognise it and the file extension needs to be .csv (.xls will work but will display an error first).

eg.

DECLARE @query_result_separator CHAR(1)...

Tools - Import and Export Settings - export your setup to file, import on the other PC's