Integration Services (SSIS)

Parse Data from a Field Containing Multiple Values using CROSS APPLY

  • Article

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

3.27 (15)

2019-06-07 (first published: )

9,364 reads

Blogs

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 9 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

SSRS - Certificate

By Tomys

Hi Team, When I am trying to configure web service URL, using HTTPS certificate...

Migrate database with encrypted columns to SQL 2016

By shahgols

Hi all, I need to migrate a SQL 2012 database that has a few...

Controlling Intelligent Query Processing Features

By Kathi Kellenberger

Comments posted to this topic are about the item Controlling Intelligent Query Processing Features

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers