Send your sql query that you are using and can help with getting values you want.

Thanks appreciate the info it is getting very annoying and if I can't set the interval this way I can turn it off.

Sorry forgot to add the DISTINCT to the SQL

SELECT DISTINCT

b.database_name 'Database Name'

,b.backup_size

,b.compressed_backup_size

,CONVERT (NUMERIC (20,2), (CONVERT (FLOAT, b.backup_size) / CONVERT (FLOAT, b.compressed_backup_size))) 'Compression Ratio'

,b.backup_finish_date

FROM

msdb.dbo.backupset b

WHERE

DATEDIFF (SECOND, b.backup_start_date,...

BikeDude -

I figure you have already figured this out and moved on but just in cae you didn't here is a query that works for me:

SELECT

b.database_name 'Database Name'

,b.backup_size

,b.compressed_backup_size

,CONVERT...

Interesting ... I did a google search on this and found some people changing row colors with code but nothing in SSMS

Not sure I understand the question completed but to change the default colors in SMSS

Tools -- Options -- Environment -- Fonts and Colors

Is this a 1 time action or is it going to be a recurring thing ? Since its not a linked server can you fully qualify the server names to...

I believe that the 64bit version of DTEXEC gets hit first if you are not specific on the file path. With that said here is a link to a good...

Well I am not sure this is going to work having errors with file. I created a dataflow and for my Source I used the XML source object then pointed...

I have not tried that will see if I can get that to work this morning.

Thanks

I am having almost the same issue our files came with .xls extensions but in reality they are web page (html) files. If I open them with Excel and do...

You could also call the SSIS package directly too if you wanted

DECLARE @sqlCmd VARCHAR(1250) -- call to ssis...

I think I would try to do it something like this:

DECLARE @myCmd VARCHAR(4000)

SET @myCmd = 'sqlcmd -d AdventureWorks2008R2 -Q "SELECT FirstName, LastName FROM Person.Person WHERE LastName LIKE 'Whi%';" '

EXEC master..XP_CMDSHELL...

It did do the trick thanks appreciate it: so now when the subscription tries to run the report I get an error and no email is sent

to users.

(code used)

IF NOT...

THanks for the info will give it a shot today and let you know how it works