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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.76 (17)

You rated this post out of 5. Change rating

2012-12-04

7,586 reads

One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...

Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...

Setting page visibility and the active page are often overlooked last steps when publishing...

Comments posted to this topic are about the item Password Guidance

Comments posted to this topic are about the item Using table variables in T-SQL

I am trying to check out elastic query between two test instances we have...

What happens if you run the following code in SQL Server 2022+?

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;