Integration Services (SSIS)

SQLServerCentral Article

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

11,678 reads

External Article

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

Daily Coping 5 Aug 2022

By

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

Daily Coping 4 Aug 2022

By

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

What’s next III

By

In case you didn’t know I was given notice about a month and a...

Read the latest Blogs

Forums

Truncate partition table failed due to index not partition. Help please.

By JasonO

I have 1 table which has a partition on Date column. However this table...

Finding Special Characters in Email Address

By sathishkm

Hi All, I have to find the special characters in email address apart from...

Three Mile Island And Your Databases

By Grant Fritchey

Comments posted to this topic are about the item Three Mile Island And Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers