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 |
|
ssis_newbee
Starting Member
8 Posts |
 Posted - 2011-06-17 : 03:42:50
|
| HI,I have my source data this wayTestId TestName Testplace TestLoc 1 Social School1 Null 2 Science Null Null 1 Null Null Hyd 2 Null School2 Null 2 Null Null MumbaiI need to Insert into the destination and the data should be inserted this way after insertion..TestId TestName Testplace TestLoc 1 Social School1 Hyd 2 Science School2 MumbaiBoth my source and destination are MS Acess. Any idea which transformation i need to use to this achieve this..Please let me know in case of any details requiredThanks before hand:) |
|
|
|
|
|
Need some kind of Union in package