Thanks Kraig .... I will try this approach.

That question was posted by me. I didn't got correct answer over there. There is no seperate forum for SSIS 2008, for that reason I posted in 'SQLserver 2008 general...

I didnot started creating package (Analyzing Stage). I think we can use 2 OLEDB command transformations (sql queries with distinct clause) in populating Locations and OfficeTypes. But how about...

I am stuck in popluating the Join Table "LocationsXOfficeTypes". Need to get those unique ID's and populate relatively.

Can you be more descriptive in your comment. Where you see invalid number of columns?

I reformed the question for understanding easily. Here it is..

I have 2 databases in different sql servers. One is my source database with plain tables(staging), other is my destination database...

what is Zombie DDL's Script....

Thanks Ninja ,

you opened my eyes, I mean after your calculations I don't want put that much of time in my life to SQL server to become an MVP.

I'll...

I think I didn't presented the question clearly.

These are not my real tables. I gave an example of my situation.

Input table is from my source database, output tables are...

Thanks for your help. It really helped me. Finally I worked out and got a similar query.

Select

object_name(rkeyid) Parent_Table,

object_name(fkeyid) Child_Table,

object_name(constid) FKey_Name,

c1.name FKey_Col,

c2.name Ref_KeyCol

From

sys.sysforeignkeys s

Inner join...

Thanks. But I want a way through SSIS.

I tried for many tables, that too join tables which will definitely have foreign keys.

Thanks jason for your instant reply.

Query executed successfully, but I am not getting any output. I gave one of my table in your script for "your Table".