Here's what I'm trying to accomplish...nothing out of the ordinary.

Ozzie

Well, the error is actually coming from SQL Server because the defined relationship cannot be established.  To better help you I need a couple of things.  I need the structure of the parent and child (at least the primary keys and the foreign key fields) and how you have defined the foreign key relationship (and which table you defined this on).

Also, what master table reference is being made here?  Is this a table in your database named master?

I'm trying out the demo of the DDT and when I create a relationship between 2 tables and go to deploy to server I get the following error:

Creating relationship 'FK_relationship' failed.
Create failed for ForeignKey 'FK_relationship'.
An exception occurred while executing a Transact-SQL statement or batch.
Foreign key 'FK_relationship' references invalid table 'master table'.
Could not create constraint. See previous errors.

There are no previous errors.  I'm using SQL Server Express.  I've tried setting the relationship from both tables as parent child, child parent with the same results.

Any ideas?

Thanks,

Ozzie