A Few Cool Things You Can Identify Using the Default Trace By Greg Larsen

A Few Cool Things You Can Identify Using the Default Trace

By Greg Larsen

http://www.databasejournal.com/features/mssql/a-few-cool-things-you-can-identify-using-the-default-trace.html

SQL Server Developer Tips and tricks

http://www.mssqltips.com/


http://www.mssqltips.com/tutoriallist.asp

• MySQL to SQL Server Conversion Tutorial
• SQL Server Analysis Services (SSAS) Tutorial
• SQL Server Backup Tutorial
• SQL Server Graphical Query Plan Tutorial
• SQL Server INFORMATION SCHEMA Tutorial
• SQL Server INSERT Tutorial
• SQL Server Integration Services (SSIS) Tutorial
• SQL Server Performance Monitoring and Tuning Tutorial
• SQL Server Report Builder 3.0 Tutorial
• SQL Server Reporting Services Tutorial
• SQL Server Restore Tutorial
• SQL Server SELECT Tutorial
• SQL Server Stored Procedure Tutorial

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS By Stan Kulp

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

By Stan Kulp

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/77306/

The attached EmailFtpXmlInvoice.dtsx demo SSIS package queries the Clients table for client ids, then loops through the client ids to:

1. Generate invoice XML code for each client using a set of FOR XML queries.
2. Save the invoice XML code to an XML file.
3. Email the XML invoice file to the client if there is an email address for the client in the lookup table.
4. FTP the XML invoice file to the client's server if there is FTP server information for the client in the lookup table.

If you don't have access to SMTP and FTP servers, the 'Install and Configure Local FTP and SMTP Servers' section of this article explains how to download, install and configure free SMTP and FTP servers for testing purposes.