Here are three links to PowerShell scripts that do this work in various methods. A Google search of "powershell sql server inventory" brings up quite a few links. Do like...

There are some powershell scripts out there that can be used to do this kind of thing. They can be coded to produce very pretty excel spreadsheet type reports. Glen...

When attempting to install the task for SSIS 2010, I encountered a problem in that it said I need to have SSIS 2010 on my system (I did). In researching...

You've not given us any code, but is the email portion of your job a step of it's own? If so, do you have the database set to MSDB?

SELECT node_id, node_state_desc, memory_node_id, online_scheduler_count,

active_worker_count, avg_load_balance

FROM sys.dm_os_nodes WITH (NOLOCK)

WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);

Yes, the role does have permission to execute the stored procedure sp_send_DBMAIL and the user is a member of the role. DBMail is enabled and a default profile is defined...

I sure wish I had seen this answer a month ago when I was trying to do that very thing! Even Redgate could not tell me how to restore the...

Thanks -- I know excel can open it just fine, but it isn't the same as it actually BEING an excel file (at least to my users who are looking...

This is very interesting to me. Could this process also be used to write to .xls file? I have a 64 bit system and using SSIS to write to excel...

Here is what I've ended up doing.

set the Is Local Path Variable back to false, created a file connection to the dummy file in the folder as my local path...

Yes, I have verified that the file is created. and I have also removed the variable reference and pasted the actual path into the ftp, run it manually and...

I am trying the same thing. I have the FTP task set to use variable for the local file, then created a variable named FullFilePath set to evaluate as expression...

Yes when you add a TABLE you have a detail row, however, at some point you must have deleted the table and gone with a tablix. Your own list of...

No, what I am saying is that you never had a detail row to...

No, Tablix took the place of Matrix and is an aggregation tool.

From Applied Microsoft Reporting Services 2008 by Teo Lachev "Tablix lets you author versatile table-style reports with multiple...