SSIS: Output SQL to XML file

I wanted to create an XML file from an SQL table using SSIS. I found the following blog, but the method I used is in the user comments from “J. Morgan Smith”. I also had to do what “sam” and “BB88” said.

http://consultingblogs.emc.com/jamiethomson/archive/2006/07/11/4209.aspx

 

Advertisements

SQL Reporting Services Date Parameters

Again, I’m posting these here mainly to assist in my own forgetfulness.

Start of Month: =DateAdd("d", -datepart("d", Today()) +1, Today())

Start of Last Month: =DateAdd("m", -1, DateAdd("d", -datepart("d", Today()) +1, Today()))

Last Day of Last Month: =DateAdd("d", -datepart("d", Today()) , Today())