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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2008-05-14 : 16:49:26
|
| Hi,I imported data into a fact table in sql with SSIS. The fact table looks like this:Question Answer Type q1 a1 t1 q2 a2 t2 q3 a3 t3The problem is that i have to insert the data from the fact table into another table that looks like this:art_id template_id Body 23 1 q1 23 2 a1 23 3 t1 25 1 q2 25 2 a2 25 3 t2How can i insert the data correctly?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
on7june
Starting Member
41 Posts |
Posted - 2008-05-15 : 08:45:53
|
| Is the field type is same in both the tables? If it is same then use a OLEDB source and OLEDB destination in data flow task, where you can map the fields from one table to another as you require.Sarvan |
 |
|
|
|
|
|
Change format of table