Great job this is one of the most reliable SQL sites on the web!

I want to agree with the set up the error output. It is also a good to run the whole set and look at all data that will cause you...

As long as you use developer edition you can either check the save package at the end of the Import data wizard and create a file. Or using visual studio...

You don't say but how is the sheet getting updated?

Is it a single user or an application feeding the sheet?

Great with access to visual studio you can create the xml and xslt schema and validators. After they are validated you can then use ADO.NET to insert the records into...

I have a question I have several packages that I run on several different servers both by using SQL Agent for the Standard and Enterprise editions and using a Standard...

Reporting services for 2005 needs to have a separate SQL license to run on a machine other than the machine it is deployed on. If you are trying to remotely...

Do you have access / license for Visual Studio .NET?

A record set in nothing more than a variable of type object.

In you data source you have a choice of destinations. Just set this destination to the variable and the...

You could create record set object and since the Excel script is fairly close and modify the recordset to output to a simple worksheet.

Just a thought

It is not recommended practice as the Excel object is well know for not closing correctly. but to do what you want you will need to install Excel or purchase...

Yes we are running x64 in a as400 shop and used to used tto and csv files to do all of the transfers from the as400. I never got the...

Congratulations!

Amazing what can be found when something doesn't work.

You can always use the old method with a cursor:

SELECT DISTINCT s_mf.database_id

from sys.master_files s_mf

where s_mf.state = 0 -- ONLINE

AND has_dbaccess(db_name(s_mf.database_id)) = 1 -- Only look at databases to which we...

This goes along with the previous answer does the user have permission to select on sys.objects on all databases?