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 |
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2010-07-12 : 14:49:00
|
| I am looking how to do this the proper way. I am pulling data from an Oracle DB to MSSQL. I need to do mapping and some conversion. I will keep this simple. Right now, I am just going to asked about 2 tables. Client and client addresses. There are multiple client addresses to each client. Client Table ClientID Client Name Addresses TableAddressIDAddress1Address2ClientIDLet’s say to make this simple. The schema is the same in both DB's. I have a data flow source and a destination. What else do I need to accomplish this?DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-12 : 15:32:56
|
| a data flow task.did you create your connection objects already? if yes, make sure to assign the proper connection to the source. then add a transformation task. now add the connection object to your destination. like i said in other thread, if you use the wizard and let it save, you can open the project in BIDS and see what it creates. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-12 : 15:36:31
|
data flow task should look something like this |
|
|
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
Posted - 2010-07-13 : 07:08:01
|
| How do I fill both tables?DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
|
|
|
|
New to SSIS