Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Load data into XML file in XML format in SSIS2005 Expand / Collapse
Author
Message
Posted Wednesday, August 01, 2012 6:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:03 PM
Points: 1, Visits: 11
Hi,

I am new in SSIS.

RPV01,VJAAP,'TRUE'

I created Query like below
DECLARE @CustomerInfo NVARCHAR(MAX)

SET @CustomerInfo = (
Select ltrim(rtrim(RPVR01)) as RPVR01,SUM(RPAAP)*.01 as VJAAP ,'False' as Creditcashonly from TESTDTA.F03B11
where RPCO ='00100'
and RPAAP <> 0 and RPVR01 between '1' and '9999999999'
group by RPVR01
FOR XML PATH('CustomerInfo')
)


Select @CustomerInfo as text


but I am not able to load in XML using script task as per this Artical

some code issue
plz can any one give me exact code for this for SSIS 2005


thanks in Adv


Post #1338486
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse