You may want to check out the article from today about Using SSIS to export data from a 64 bit server to Excel 2007 [/url].

I've tended to use the 32-bit...

In fact, my CTE tally table is a calendar table (note: TALLY(N) AS (SELECT DATEADD(month, N, 0) FROM CTE6) ) of months starting at 1900-01-01 and ending with 9999-12-01 (total...

To follow-up my earlier suggestion, note that Cadavre's approach uses a tally table. A calendar table is a specialized version of a tally table.

It's a powerful tool. In...

Try building a calendar table, joining on your dates. Then you can aggregate by month using the month values in the calendar table. See the following article[/url]...

You may want to look into user defined functions. See BOL or this MSDN article on UDFs for further details.

You may also find this article by Erland Sommarskog helpful.

I've found that when I get errors that aren't clear to me, doing an internet search for the error code will often be helpful. There isn't enough information in...

You may also find this recent blog[/url] post on SSC helpful.

Cross post. See:

http://www.sqlservercentral.com/Forums/Topic1374114-364-1.aspx

Cross post. See:

http://www.sqlservercentral.com/Forums/Topic1374114-364-1.aspx

Hi Learner,

A suggestion and a question. The suggestion. It's very helpful if you do not cross-post your questions. That keeps the responses in one place. Folks...

A couple of resources to get you started:

Stairway to Integration Services[/url]

Connecting to MySQL from SSIS. I haven't had to connect to MySQL but it appears that this blog post...

If you want to begin to explore an SSIS solution, use the Import/Export Wizard (SSMS-->Select Database-->Right click, Select 'Tasks' and from there Select 'Export Data'). Walk through the wizard....

Based on the two sources mentioned in the prior post, here's a possible approach. First, create the data. I've added a second member based on the structure of...

Check out this SQL Spackle article by Jeff Moden:

Group Islands of Contiguous Dates[/url]

If you got access to a copy, also helpful is the discussion about 'Islands and Gaps' in 'TSQL...

You'll need to execute a SQL task for each tab using an EXCEL connection manager pointing to the output spreadsheet. The SQL task contains the DDL to do the...