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,615 reads

If you want to learn better, pause more in your learning to intentionally review.

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...

Ramblings of a retired data architect Let me start by saying that I have...

Not sure if this is really a relational theory question but it seems about...

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

Hi all, I recently moved to a new employer who have their HA setup...

I have this data in a SQL Server 2025 table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?