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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-09 : 08:22:54
|
| Swati writes "HiRecently, I installed SQL server 2005 with DTS service, which I suppose is also called SSIS. I am trying to build a DTS package which should transform data from source DB to Destination DB(Both are SQL servers) in such a way that the fields from a single source table gets inserted into multiple destination tables. For example, I have a source table that contains person details such as Name, Gender, Nationality, work address, work phone number, home address, home phone number etc. Now, when I transform the data to destination table, the Name, Gender, Nationality goes in one table, say PersonProfile and Work Address, Work Phone Number goes to Separate Table, say Contact Info as one row and Home address and Home Phone Number also goes into ContactInfo table but as a separate row.Entry in ContactInfo table generates a Contact Info Id, which should be used in PersonProfile table as a field.Please suggest me a way to do this.ThanksSwati Arora" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-09 : 14:09:10
|
| So how far did you get? Have you opened up Visual Studio or did you want us to do that for you?Tara |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-09 : 14:15:14
|
| [smack] Ouch!JimUsers <> Logic |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-09 : 14:27:22
|
| Actually you could open the Business Intelligence Development Studio too, it's 1 or 2 fewer mouse clicks to set up a transform than Visual Studio would be. |
|
|
|
|
|
|
|
|
SQL Server 2005 - DTS