Re: how to create csv file in DTA
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/04/04
- Next message: Darren Green: "Re: SQLEM: Package Error: "The system cannot find the file specified." on open of DTS Package"
- Previous message: Allan Mitchell: "Re: Rename Destination Columns"
- In reply to: Kanan: "Re: how to create csv file in DTA"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Jun 2004 09:46:18 +0100
That select returns rows right?
You need to name all attributes so
sum(convert(int,Volume,12))
would need to be
sum(convert(int,Volume,12)) as ABC
Go to the transformations tab and make sure the SourceColumns appear as you
expect and the map to a DestinationColumn.
-- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Kanan" <anonymous@discussions.microsoft.com> wrote in message news:EE9716BC-8D45-4AF7-B338-82A4B2F3E5E7@microsoft.com... > thanks you very much for the info. But I have a query like this. but for some reason, the last 3 columns in my select > clause don't appear in the output csv file. > > select INTSYSTID, DATEE, cpt_code, > MOD,COL1,COL2 ,sum(convert(int,Volume,12)) > from dwpublish..KANAN_Q12004 > group by intsystid,DATEE,cpt_code,mod,COL1,COL2 > order by intsystid,DATEE,cpt_code > > any clue would be greatly appreciated. > > thanks > Kanan
- Next message: Darren Green: "Re: SQLEM: Package Error: "The system cannot find the file specified." on open of DTS Package"
- Previous message: Allan Mitchell: "Re: Rename Destination Columns"
- In reply to: Kanan: "Re: how to create csv file in DTA"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
