Friday, February 24, 2012

Integration Services log report pack - provided by Microsoft - US date format issue

Hello all,
Microsoft provides a report pack of RS reports to use with
Integration
Services standard logging.
The link is here
http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en#QuickInfoContainer
I have been trying to use these reports in the UK and have come
across
a problem with the date formatting. The reports seem to expect the
date formatting in the report parameters to be in US format. I have
changed all the report language settings to UK - English and the date
formatting in the datasets that supply the parameter values all use
ANSI dates (format 102), but I still get date conversion errors when
trying to return the datasets unless I input the dates in US format.
Any advice on how to get around this issue would be greatly
appreciated.
ThanksOn 26 Mar, 14:31, "weelin" <wee...@.gmail.com> wrote:
> Hello all,
> Microsoft provides a report pack of RS reports to use with
> Integration
> Services standard logging.
> The link is herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad...
> I have been trying to use these reports in the UK and have come
> across
> a problem with the date formatting. The reports seem to expect the
> date formatting in the report parameters to be in US format. I have
> changed all the report language settings to UK - English and the date
> formatting in the datasets that supply the parameter values all use
> ANSI dates (format 102), but I still get date conversion errors when
> trying to return the datasets unless I input the dates in US format.
> Any advice on how to get around this issue would be greatly
> appreciated.
> Thanks
As a follow-up, I have found that the only way to run the report is
via Internat Explorer browser AFTER setting the locale of the browser
to US-English so that it passes the date parameters in the correct
format. Obviously, this is not a practical solution, so if anyone has
found a proper solution, please let me know.
Thanks

No comments:

Post a Comment