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,895 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

Disks performance in Azure

By

In our earliest post, we have discussed in detail about the factors that affect...

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Read the latest Blogs

Forums

Query help for special condition

By sqlenthu 89358

Hi sql gurus, I am currently doing some R&D on MERGE statement and as...

Going Back to the Basics

By scott.fountain

In the past couple months, I have helped people understand a handful of topics...

Advantages and Disadvantage using Temp Table or Fisical Table

By fransiscuscandra

Please share your thought about advantages and disadvantages for processing using temp table or...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers