I created a DTS package does the following:
1. execute stored procedure, output results to a table
2. selects from the table and exports to Excel
When I open up my Excel sheet, I noticed that the numeric fields (numeric fields from my source table), cannot be summed or change data types. In my transformation from my table to my Excel sheet, the data types on the destination settings are automatically varchar(255). I'm positive that that is why I cannot sum any of the columns in my Excel however, I have no idea how to get those data types to change in my transformation. Specifically, I need them to change to doubles. Any ideas?
1. execute stored procedure, output results to a table
2. selects from the table and exports to Excel
When I open up my Excel sheet, I noticed that the numeric fields (numeric fields from my source table), cannot be summed or change data types. In my transformation from my table to my Excel sheet, the data types on the destination settings are automatically varchar(255). I'm positive that that is why I cannot sum any of the columns in my Excel however, I have no idea how to get those data types to change in my transformation. Specifically, I need them to change to doubles. Any ideas?