Thomas Stricker


SQLServerCentral Article

SSIS Package with a Derived Column

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.

(3)

You rated this post out of 5. Change rating

2018-02-06

3,794 reads

Blogs

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Do This Before You Contact Your SQL Server Consultant

By

Say you need outside help. You’ve exhausted all the things that you could do...

Microsoft MVP 2026: Ten Years on the Data Platform

By

I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...

Read the latest Blogs

Forums

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

BIT_COUNT() III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() III

The Mythical Bus Accident

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Mythical Bus Accident

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)
What is returned?

See possible answers