Keith,

What is the exact error message when the job executes? Probably a silly question but you have checked the [enabled] box to the right of the Operator Name when...

You'll need to turn on logging in SSIS, this will provide important information as to the issue. I assume you've taken the syntax and executed it successfully in a...

Try look at http://www.sqlservercentral.com/articles/tempdb+utilization/65149/

The following will give you the amount of free space within tempdb:

SELECT sum(unallocated_extent_page_count) [Free_Pages],

(sum(unallocated_extent_page_count)*1.0/128) [Free_Space_MB]

FROM sys.dm_db_file_space_usage

This script will show you which SPID takes up the most space...

Can you post the failure message?

It sounds like you do not have the full SSIS client installed from the SQL Server installation CD.

BIDS ships with SQL Server but you can only get SSIS with SQL...

Can you please confirm what you mean by "the package is not running"?

The the SSIS task execute and then fail or execute reporting success but not actually perform the operations...

Hi,

I couldn't see a link to the articles in your reply, would you mind posting again?

Many thanks,

Chris

Hi guys

Thanks for all your comments, they've given me a great starting point. With regards to the following comment could someone please explain what it means or point me...

Thanks guys for your comments, they are really useful and greatly appreciated.

So from the information you've provided I going to look to do the following:

1. Look at the ordering of...

Thanks guys for all your help, using the information provided I've managed to put together a working solution!

Your help is greatly appreciated.

Thanks Michael the conversion worked.

Thanks for your reply, the server running SQL Server 2005 Enterprise Edition is running on an Enterprise platform and therefore SQL Server will only get restarted maybe once a year...

Hi Elisabeth,

Thank you very much for the information, it's greatly appreciated.

Do you happen to know the default retention policy for information returned from the DMVs, or is it a case...

Hi,

Thanks for your comments, much appreciated.

The problem I have is that our company has a peak for 2 weeks of the year in July, the rest of the year the...

Thanks for your help guys, you've been fantastic!