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