I'm trying to use a Data View Web Part in order to roll up data from 2 separate
libraries/lists that live in seperate sites as shown below:

1) Site Description List in "Product A Site" - (column: Product Name)
2) Contracts Library in "Admin Site" - (columns: Product Name, Vendor, Title)

The DVWP resides in "Product A" and must only list "Contracts" where the "Site
Description Product Name" column (in Product A Site) matches the "Contracts
Library Product Name" column (in Admin Site).

I accomplished this using Sharepoint Designer by linking both libraries (data
sources) and then adding a filter in the DVWP where both Product Name columns
match. Everything works great.

My problem is I saved out the "Product A Site" as a site template and created a
new Product Site (Product B Site) based off this template. The DVWP in the
newly created Product Site throws the following error:

"Unable to display this Web Part. To troubleshoot the problem, open this Web
page in a Windows SharePoint Services-compatible HTML editor such as Microsoft
Office SharePoint Designer. If the problem persists, contact your Web server
administrator."

I suspect this is because the DVWP DataSource is still pointing to the "Product
A Site Description List". Is there a way to set the DVWP so that the "Site
Description List" is dynamic and points to the "current product site" and not
the "original product site"?