SSIS - How to bring out month as two digits, i.e 07 instead of 7.

Question

Hi All

The SQL I have written shows the month as 07 when I put a viewer on the flow. However, as soon as it hits the 'sort' function and check the data, the month now comes out as 7, and I cannot get it to show it with 2 characters, any ideas.

Answer 1

Hi @neilsja ,

Could you please show the datatype in the sql server of the month column for us?

I tested locally that I couldn't reproduce your issue.

You may also help check the datatype of month in sort1 advanced editor.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

An implicit conversion to numeric has happened somewhere