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 |
|
Rheinhardt
Yak Posting Veteran
66 Posts |
 Posted - 2011-05-10 : 03:33:39
|
| Hi,I have xml files as my source and want to integrate into SQL DB destination staging tables.The problem I have is that for example my one file Itemmaster file, has mulitple entities/outputs. Therefore containts the required data being scattered allover different outputs/entities and also data that I dont need, for example Item name in one output/entity and Item Leadtime in another, but I need this to integrate into one table in SQl DB.Is there a function in SSIS were I can link one source file with multiple outputs/entities to one destination table?(merge,map or link these outputs...?)Many Thanks |
|
|
|
|
|
XML SSIS integration