I have imported the tables from excel to my database which does not have the
FK relationships, Now i need to check the relation check in the imported
database regarding this i have some queries, any help on this is
appreciatable.

1. How can We check the Relational check(Checking child records in Master
tables) in the database using DTS.
2. In DTS, How do make use of the Dynamic Properties Task,
3. In DTS How do we access the global variables across the packages

Regards
Krishna

Regarding your first query, you simply have to use SQL queries from an
'Execute SQL' task to validate your data. The rest of your queries are
answered at www.SQLDTS.com
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote

I have imported the tables from excel to my database which does not have the
FK relationships, Now i need to check the relation check in the imported
database regarding this i have some queries, any help on this is
appreciatable.

1. How can We check the Relational check(Checking child records in Master
tables) in the database using DTS.
2. In DTS, How do make use of the Dynamic Properties Task,
3. In DTS How do we access the global variables across the packages

Regards
Krishna

The DP task is where we take a property in a package and assign an external
value to the value of that property. An example would be reading the
ConnectionString Property of a text file connection from an ini file.

We have something similar here.

www.sqldts.com/default.aspx?252

You can pass GVs between packages by either using the DTS object model
AND/OR using the ExecutePackage task.

Allan
www.SQLDTS.com




"Krishna" wrote: