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.67 (3)

You rated this post out of 5. Change rating

2018-02-06

3,357 reads

Blogs

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Read the latest Blogs

Forums

A Partial Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Partial Count

The Stagnant Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Stagnant Career

Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)

By Erin Dempster

Comments posted to this topic are about the item Stairway to Database DevOps Level...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers