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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ssis- creating a unique customer details

Author  Topic 

shravanigonela
Starting Member

2 Posts

Posted - 2009-03-04 : 22:27:37
hi, I am new to SSIS and i need help ...
Example .....I have 150 tables in a database which has a customer table in it.....
when the customer comes to the site and fills his information the data is saved in different tables.....
and we have to export the data into excel sheet such that there should be no duplications if the customer created 2 -3 ids.So, the output should have the customer unique information...

can anyone help me how to create this logic in SSIS.........

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2009-03-04 : 22:47:57
Can I check with you if any of the tables you are supposed to join to customer information in the database has a one to many relationship?

check out my blog at http://www.aquariumlore.blogspot.com
Go to Top of Page
   

- Advertisement -