What happens if you run it in SSMS? Also, that error message does not look like one generated by SQL Server....

Have two ForEach loops - one for txt files, and one for Excel files.

John

I'm guessing one or more of your databases have a case-sensitive collation. The name of the INFORMATION_SCHEMA schema and the views within it are upper case.

John

What errors are you getting?

Actually, I would urge you not to split the dates into their constituent parts. Store them in the database as datetime, and perform any manipulation...

You can get the most recent backup file for each database like this:

SELECT

r.DBName

,r.type

,r.BackupStart

,s.backup_finish_date

,s.backup_size

,m.physical_device_name

FROM ( --gets most recent of each type of backup for each DB

SELECT

d.name AS DBName

,b.type

,max(b.backup_start_date) AS BackupStart

FROM master.dbo.sysdatabases...

Are you backing up with a maintenance plan? The file name contains a time and date stamp, so it will be different every time.

John

Can you temporarily comment out the INSERT part of the script to see what you are trying to insert? You could be attempting to insert more than one row...

Please will you post your INSERT statement and the error message.

Thanks

John

Of course I do. A good debate is a good debate, and if we can...

All that casting from int to to varchar looks messy to me - that's all...

Are you saying you just want to add "of x" to the Rank column, where x is the row count for the city in question? Do you want to...

Backups can be set to expire - this is when the backup set can be overwritten with a new one. The maintenance cleanup task is different - it deletes...

When you say you've had no luck, do you mean you got an error message, or did you get the wrong results? What did you try? Here's a...

Try this: http://www.sommarskog.se/dynamic_sql.html

John

http://msdn.microsoft.com/en-us/library/ms188001.aspx

If you want more detailed help, post the code and post the error messages.

John