November 11, 2024 at 11:59 am
Good Morning,
I have built an SSIS package which produces Excel File Output. In the course of the Run, the package itself makes a copy of the Template Excel file before populating it with the new data. One of the fields is called 'Count' (it is actually stored as a Varchar in the SQL Table).
As a result, in MS Excel I am obliged to perform Convert to Number which will allow me to build a Pivot Table with the new data.
Kindly advise, if there is a way to ensure that 'Count' is automatically a number in the Output file after the package runs. I have already tried these:
In spite of these efforts, the column 'Count' is still requiring manual Convert to Number for purposes of aggregation for Pivot table.
Kind Regards
November 11, 2024 at 1:08 pm
It's been a while since I've had to do this, so I just created a dummy package to work it out again.
Here are the steps that I took:
That should do it. Of course, you'll need to exclude the dummy row from your pivot.
November 11, 2024 at 6:31 pm
Thanks, Phil. Resolved !
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy