Dynamic Setup of Connection String for the Data Source in Data Connection Library (SP2010)

Question

I have to update the SSRS Datasource connection string in Sharepoint Data Connection Library by coding.

I have a SSRS report in a SP2010 team site that gets the data from Sharepoint lists inside the team site. So the data source connection string is Site Url itself. The site has been saved as an template and I have the job that creates the new team site based on the template.

When the job creates the new site and the SSRS DataSource connection string is pointing to Template site URL, and every time someone have to change it manually to point the new site URL. But I like to change the connection string inside the job . I can access the Datasource as an list item but connection string. Any Idea how to update the connection string programmatically.

Your Help is appreciated.

Thanks

Dhans.

Answer 1

Hi Dhans,

Thanks for your post!

I am trying to involve some one familiar with this topic to do some further research.

Thanks,
Simon

---

Simon Huang

TechNet Community Support

Answer 2

Thanks Simon.

Answer 3

Possibly you can use WebProvisioned event receiver to upate the connection string after the site is created (much easier).

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spwebeventreceiver.webprovisioned.aspx

Or

Feature stapled to site creation process which updates the connection string.

http://blogs.msdn.com/b/vesku/archive/2010/10/14/sharepoint-2010-and-web-templates.aspx

Answer 4

Manish,

Let me try the "WebProvisioned"

Thanks

Dhans.