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: )

8,662 reads

SQL Server Integration Services SSIS 2016 Tutorial

  • Article

SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.

2017-10-06

4,301 reads

Blogs

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

SQL Undercover TV – Instant File Initialisation

By

Adrian has a look at the performance benefits of instant file initialisation Below is...

Read the latest Blogs

Forums

Leveling up Core Skills: A Pattern for Launching an Internal Training Initiative

By Julia Hayward

Comments posted to this topic are about the item Leveling up Core Skills: A...

Database Normalization in SQL with Examples

By Gouri Shankar

Comments posted to this topic are about the item Database Normalization in SQL with...

SELECT and Locking

By Kendra Little

Comments posted to this topic are about the item SELECT and Locking

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers