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)

498 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,159 reads

Blogs

It is Friday, the queries are running, and nobody is watching the bill. That...

Annabel retired from Redgate Software this week. Across most of my career at Redgate,...

As a SQL Server DBA with years of experience tuning production environments, I’ve seen...

WhatsApp: 0817839777 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112

WhatsApp: 0817839777 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211

WhatsApp / CS:0817839777 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...

When running bcp on Linux, what is the field terminator?