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)

485 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,098 reads

Blogs

If you're an attendee at the PASS Data Community Summit this year, there are...

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...

Comments posted to this topic are about the item Personal Contact Is Vital

Comments posted to this topic are about the item Getting the Schema for Tables

Comments posted to this topic are about the item An Unexciting Exciting Release

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO