I would start w/ the T-SQL in the report. Look for the ususal suspects, missing indexes, statistics, etc. Profile the T-SQL, look for high reads/writes. Try running an update statistics...

Although MS doesn't recommend clustering SSIS, you can avoid these types of issues by doing so. I've personally never experienced a problem with it.

http://msdn2.microsoft.com/en-us/library/223c3a59-84c3-4f60-be98-a8daf69e9473.aspx

Are you certain these files don't already exist on the server? If they do, delete them and/or move them to an alternate location.

i.e. 'F:\MSSQL\Data\Prod_Data.MDF'

In a perfect world on a 15k drive formatted at 8K block size NTFS on a RAID 1. Given your hardware (above) and assuming you have the space to accomodate...

Jasper Smith once posted this a while back -

"We use a combination of VMSTAT.EXE to get the total free and xp_memory_size

(comes with SQL Litespeed) to get the max...

Hmm. I've seen this in the past when both MSSQL 2000 tools and 2005 tools were installed along side eachother...

Running SP2, correct? Could possibly be some issue with the DCOM...

Do you happen to have MSSQL 2000 tools installed along side 2005's management studio?

For clarification, you've already installed the DTS components from the feature pack, correct?

(http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en)

Have a look through the log files under C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles. Also, refer to the troubleshooting steps in BOL - http://msdn2.microsoft.com/en-us/library/aa256414(SQL.80).aspx. Good luck 🙂

You should be able to join up to sys.partitions on object_id,index_id and pull the partition_number.

Figured it out - some old stats left over from DTA 🙂

Could it be an FW issue? Can you telnet to the MSSQL server on TCP 1433 from wherever the package is running. i.e. Start -> Run -> cmd -> telnet...

Can you verify your SMTP relay via telnet - i.e.

technet.microsoft.com/en-us/library/003e4901-884f-4bc7-b3c3-557add4e5c3a.aspx

While this article doesn't directly answer your question and assumes some level of SSIS knowledge - it should point you in the right direction. In this example the author is...

Can you check your authentication type? Go to Database mail configuration wizard -> Manage Existing account check the SMTP Authentication. Select the windows Authentication.