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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Garima Sharma » Parsing an ADO result set into a comma...

12 posts, Page 2 of 2

««1 2

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

Rate Topic

Display Mode

Topic Options

Author

Message

petr.novak

Posted Thursday, September 02, 2010 12:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 3:57 AM
Points: 1, Visits: 28

Hello,
try this select (this pivots rows to one string row):
select stuff((select top 10 ',"' + code + '"' from Products order by code for XML path('')), 1, 1, '');

Post #979319

stephen.bray

Posted Tuesday, April 09, 2013 10:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 11:55 AM
Points: 1, Visits: 3

Hi. I have tried to following your example posted here verbatim, however, whenever I execute my package it fails on the Execute SQL Task within the Foreach loop. I get the following error
"Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query ""SELECT '"+@[User::FileList]+","+@[User::MissingFi..." failed with the following error: "Incorrect syntax near '+'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task"

What should I look for that I may have overlooked earlier?

My variables
name datatype value
sql_str String "SELECT '"+@[User::FileList]+", "+@[User::MissingFileName]+'" as FileList"
MissingFiles Object
MissingFileName String
FileList String

Post #1440447

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions