14 comments

  1. This is perfect!! I’m working in 4 different SSRS environments with the same reports to deploy. This really helped the my automated deployment process.

    Thank you so much!!!

    –Sven

    Sven Beantwoorden

  2. Awesome thank you very much

    Diego Valenzuela Beantwoorden

  3. This has save me a ton of time. Thanks very much for sharing.

    JustMike Beantwoorden

  4. thank you so much for this! We spend way too much time manually updating the Report Manager site with reports.

    Sandy Beantwoorden

  5. You don’t want to link a report datasource to a Shared Datasource if the datasource in the report is embedded (DataSourceDefinition vs. DataSourceReference), right? How do you check that the item datasource type is DataSourceReference? I’ve been banging my head against a wall trying to do this. I’m pointing at a report where the XML clearly says it’s a Reference and when I inspect the Type of the Item returned by GetItemReferences it always says DataSourceDefinition!

    Richard Schaefer Beantwoorden

  6. Hi,
    I have tried using the above code, but I get an error message when setting the data source. I can not figure out.

    Cannot convert argument “DataSources”, with value: “SSRS.DataSource[]”, for “SetItemDataSources” to type “SSRS.DataSource[]”: “Cannot convert the
    “SSRS.DataSource” value of type “SSRS.DataSource” to type “SSRS.DataSource”.

    Any suggestions or help?

    Scott Beantwoorden

  7. Thank you for these scripts. How can I specify a path and folder for downloading reports and for the source of the uploading script?

    Doug Beantwoorden

    • The examples provided all use $pwd (i.e. the current working directory) as the directory to read from/write to, you could change that to any path you like.

      Léon Bouquiet Beantwoorden

  8. This article saved me a lot of time when migrating a SSRS instance, and is very well written.

    Thank you!

    Pontus Sjöström Beantwoorden

  9. This article was of great help for me but I noticed that the new site template placed all code on one line and thus ruined formatting and readability.

    Vincent Beantwoorden