Nothing wrong with your query

the problem is with

sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, NULL)

Which is always going to take a long time to run

I can highly rate these 2:

http://www.amazon.co.uk/Microsoft-Server-2005-Integration-Services/dp/0672327813/ref=sr_1_24?ie=UTF8&s=books&qid=1242306368&sr=8-24

http://www.amazon.co.uk/Microsoft-Server-Integration-Services-Step/dp/0735624054/ref=sr_1_3?ie=UTF8&s=electronics&qid=1242306352&sr=8-3

both refer to 2005 but a lot of the principles are the same

I wouldn't recommend using the import/export data tasks to generate SSIS for you...

I'm not sure about the % complete.. i don't think it can be done as it would mean the DTSExec process knowing how much was to be done before the...

I can show you...

I think the problem might be in your query

I just ran it and got way too many records returned

Usually reports are viewed through an intranet connection

http://YourReportingServer/reports

use the row_number function instead

SELECT

row_number() over (order by ExecutionLog.UserName) AS RowNumber,

ExecutionLog.UserName,count(ExecutionLog.UserName) as HowManyReportsRan

FROM

Catalog INNER JOIN ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE

ExecutionLog.UserName NOT IN ('NT AUTHORITY\SYSTEM','NT AUTHORITY\NETWORK SERVICE')

AND(NOT (Catalog.Path LIKE N'/Users...

a BCP task might be a better option if the file structure is straight forward.

Alternatively use a script or derived column task to split 1 column into several

Problems are:

Can the centralised server see all the servers which the packages need access to?

Is there going to be an issue with huge amounts of data travelling over the network....

you need even more quotes!

set @sto = '''''Pepe'''''

This will double quote the Pepe within the variable so when you add it to the other string it has the right number...

Its a windows smart phone!

You can use any WAV file for your alerts...

http://forum.xda-developers.com/showthread.php?t=263174

XDA Developers is an extremely good resource...

Joe (5/13/2009)

---

Jonathan;

I am OK with SMS; that is what I am using now; The only problem is ring tone; when I am sleeping I want something to ring for a...

I think you want something like this

select case when amount 15000 and terms 15000 and terms between 12 and 60 then amount else null end as criteria3

from...

Kit G (5/13/2009)

---

Cool. Thanks. I've wanted one for a while. Glad to know you can do some upgrades to them without having to send it back to...

This could be done dynamically in SSIS if you break away from the standard data flow model.

First questions though

Is this excel 2003 or 2007

How many rows of data are there?