Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashwinreddy
Starting Member
1 Post |
 Posted - 2012-03-20 : 01:51:41
|
can anyone help me in ssis while establising the relation between two tables..i have tables like------------opportunity table------Opp_id Client_id CoE_Id Oppname_Id Value(M USD) Opp_entrydate Startingstatus Submitted date PK,int FK,int FK,int FK,int Numeric(18,2) Date time Status_id(FK,int) Date time ------------bids table------ Bid_id Client22_id Client_business_id Coe22_id Offering_id CoeFocusarea22_id Effort_id Opp_id FK,int FK,int FK,int FK,int FK,int FK,int FK,int FK,int here i need to relate bids table and opportunity table. in bids table i have colomn called OPP_ID so that id should refer that opportunity table. after genereted the relation between tables all records(values) should be correct when we comparing with the main excel sheet. i need complete screen shorts or code. |
|
|
|
|
|
|
|
tables relationships(reply to this topic now)