How about setting '_blank' as the target ??

If the structure of the sheet remains the same for each sheet, you can change the name of the source easiliy enough using a dynamic properties task. The tricky part...

From Books Online

"When GROUP BY is specified, either each column in any non-aggregate expression in the select list should be included in the...

The sort order is by username.

If you've got any suggestions, problems, etc... post it in the feedback forum

http://www.sqlserver.org.au/forums/ShowForum.aspx?ForumID=6

Good to see you finally registered over at ASSUG

Actually it should probably go in the DTS forum

http://www.sqlservercentral.com/forums/messages.aspx?forumid=19

Is your Excel -> SQL transfer a datapump task? If so, make you turn on the "Close connection on Completion" option in the workflow properties of the task.

There is a good article on this over at http://www.sqldts.com.

I really don't know what the fuss is about here. I've used the FREE dts FTP custom task from http://www.sqldts.com for months without problems.

We FTP files from about half-dozen...

If you run sp_help for a table the foreign key relationships should be at the bottom of the output. If there not there, then maybe they don't exist.

Another quick method...

Is this a default SBS install? Can the Win XP connect to another non-SBS SQL Server?

As for the registry settings, SBS normally installs SQL as a named instance, therefore the...

Try EXEC sp_help '<object name>'

Full syntax and description in Books Online.

Make sure you take a look at this article on DTS best practices,

http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

For books, you can't go past SQL Server 2000 DTS by Wrox

http://www.amazon.com/exec/obidos/ASIN/0764543687/qid=1112136838/sr=2-1/ref=pd_ka_b_2_1/102-4883017-0150500

Is this in the Configuration Tool? If so, you will only see the Performance Collectors there. The collector reads from the XML configuration file to gather the data from the...

What problems are you having? We've been using xp_smtp_sendmail for over 18 months without any issues.