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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(14)

You rated this post out of 5. Change rating

2010-09-01

9,417 reads

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...

CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...

CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros