I don't see the April 2008 end of mainstream support mentioned any more on the Lifecycles page:

http://support.microsoft.com/lifecycle/?LN=en-us&x=8&y=10&p1=2852

Holly

Jim,

When you say tools, do you mean SSIS?  SP2 and GRD2 have been applied on the server where SQL 2005 and SSIS are installed.  I did not actually apply the...

Lynn,

Thank you very much.  I never tried this, because I script tables by right clicking on the table in Object Explorer, and that option is not available there.  This is...

It's not quite so simple in SSIS.  Open the SSIS package, right click in white space, choose Logging.  There you can choose where you want your logs to go (text...

Thanks, Michael, I will experiment with that, maybe that is the solution I am looking for.

Holly

This answer may not address your situation exactly, but the situations where I have used FullResultSet I have mapped it to a variable of type object, based on the example...

Well, I could try that and it will be interesting to see if it succeeds or fails, but it does not enable me to use the Send Mail Task inside...

The workaround that I am using is to use sp_send_dbmail in an Execute SQL Task in the SSIS package instead.  That runs fine by a SQL Agent job.  But I would...

Perhaps I should also add that the SQL Agent job sends the job completion notifications fine, both when Agent is set to SQLMail or when set to Database Mail.  This is not...

I will answer my own question -- I found I no longer had a MsDtsSrvr.ini.xml file, and I had to recreate that in the right folder and then stop and start the...

I was annoyed that it wasn't more obvious how to set the install locations for the various components in the installation, found it in the Advanced tab on the second...

Vandy,

We do this daily using the Execute SQL task in a DTS package to call a stored procedure which sends the email with xp_sendmail.  We maintain email addresses for a...

I put the following Active X script task in complicated packages with many tasks.   It puts a list of the default step names and descriptions in the log file.  It...

We have a number of SQL Server 7.0 servers in the AD environment and have not had any trouble with them.  It's been about a year, but as I remember...

As others have noted, just listing # of DBA's and # of servers or DB's may be comparing apples to oranges. For instance, here our infrastructure group does all...