I am importing data from sql(SQL2007) table to Excel file(office 2007) using the Data flow Task.
After importing data ,i m not able to make calculation,because all the data convert in to Text formate.
For Example:I have table called "Employee Detail" with two column:
Employee Name salary
Now I will import all record in to Excel File using the DFT.
there are two ways:Generate the Excel file dynamically or Create a Excel Template.
I try both ways,but Still salary column data import as a text,because of that i am not able to make calculation on Excel.
Check the meta data in the flow and make sure the source data is truely numeric. If it is, then it shoud export to Excel that way, at least I have never had that problem. You may need to recreate your destination Excel sheet with the correct data type.
Thanks for reply.
My Source is Decimal like (2348.456),even if my source is int ,data is move as a Text formate only.I also change the destination Excel column Property to data type number.
Yes,if i put the number like (00.00) in the first row in my destination excel template then all the row's for that column act as a number ,and i am able to make calculation,but unfortunately that is not the solution of my problem.
1.Chk the Sequence:package
2.Create the Dynamic Excel File :
3:Oledb Source is
selectFirstName,MiddleName,LastName,BirthDate,Gender,EmailAddress,GeographyKey as YearlyIncomefrom DimCustomer
in the DFT