format_string = 'MM/DD/YYYY' mdx in ssis coming without pading Zeros
Hi All i am getting results from cube and storing in sql server using ssis . the date format i want is 'MM/DD/YYYY', so i am using the format_string = 'MM/DD/YYYY' , it is working fine SSAS Managment studio but in SSIS it is coming without Pading Zeros. Example 09/30/2011 is coming 9/30/2011 and 10/02/2011 is coming like 10/2/2011 , how to get pading zeros in ssis output . Surendra Thota
October 3rd, 2011 10:17am

Hello Surendra, not sure how you harvest the data, but one common approach in SSIS to reformat the data is to use the Derived Column Transformation. In which you will need the right SSIS Expression. Example formatting: http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.htmlArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 10:37am

Hello Surendra, not sure how you harvest the data, but one common approach in SSIS to reformat the data is to use the Derived Column Transformation. In which you will need the right SSIS Expression. Example formatting: http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.htmlArthur My Blog
October 3rd, 2011 5:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics