Garima Sharma

Parsing an ADO result set into a comma separated string in SSIS

This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.21 (14)

You rated this post out of 5. Change rating

2010-09-01

9,347 reads

Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...

This was one of the original values: The facing page has this text: No...

For decades, enterprises have thought about data like plumbers think about water: you build...

Comments posted to this topic are about the item Create an HTML Report on...

Comments posted to this topic are about the item I Love Editorials

Hi everyone I have a 1000 plus line query and I am getting an...

What happens when I run this code:

DECLARE @s VARCHAR(1000) = 'apple, pear, peach'
SELECT *
FROM STRING_SPLIT(@s, ', ')