Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-06-08 (first published: 2017-06-01)

488 reads

List Expressions and Values of Variables in SSIS package

Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-11-17 (first published: 2015-10-18)

2,100 reads

Blogs

Even preparing for a class or seminar with set materials takes a lot of...

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

This image is from 2010, and it goes along with my last post of...

I have a login I need to deny connect to on a server, but...

All week we've had issues with the site being up and down. There's been...

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?