I am working on creating a flat file from a datatable. I have not been able to get this to work. Attached is my specification and dotnet code. Also could you take a look at my sql and see what am doing wrong. The text file is generated but the columns are not in the right position.
Here is the sql
substring(Year, 1,4) as "AWARD-YEAR",
)as SSNO ,
substring("Alternate ID",1, 10)as "id-alt",
, 1)as "NAME-M",
substring("Fund External Name", 1,35)as "fund_external_name",
substring("Award Amount",1,5)as AWARDAMT