I'm working on a script (utilizing rs.exe scripting tool), that saves subscriptions from report server and allows creating the subscriptions on a different server.
Everything works fine except a problem with subscription locale. The problem is that when the script attempts to create a subscription, it does not know which locale to use and may fail on format of parameters (especially date parameters). There is no parameter for the local, when creating a report, but you can update the subscription later on. The symptom using a foreign language for email-subscriptions can be a different format for the subject line, too. You can see
- "... wurde zum Zeitpunkt '3/19/2012 9:15:10 AM' ausgeführt."
- instead of "wurde zum Zeitpunkt '19.03.2012 09:15:10' ausgeführt.".
Here is the script to update all subscriptions to a german locale:
UPDATE [ReportServer].[dbo].[Subscriptions]
SET Locale = 'de-DE'
WHERE Locale = 'en-US';