Krista Olson

Interests: Building Quality databases with a purpose! Also mom to two busy kids, and President of McDill Lake District

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2012-12-04

7,617 reads

In last months one of the scenarios where you can use AI has been...

Do you spend so long manipulating your data into something vaguely useful that you...

It was neat to stumble on this in the book, a piece by me,...

Comments posted to this topic are about the item Fun with JSON

Comments posted to this topic are about the item Creating JSON II

Comments posted to this topic are about the item Engineer Lessons

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO