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 |
|
kondap
Starting Member
6 Posts |
 Posted - 2009-01-19 : 13:40:13
|
| HiI am using sql server 2005 with Windows XP. I have a question on how to load xml data into sql server by applying business logic dynamically.Question: The input is XML file which will have 5000 records. Before loading data into sql server destination tables , I have to apply business logic (2-3 level). what is the best way to achieve this?Would it be feasible to write a stored proc with business logic and call this proc for each record in xml (5k), its a performance overhead I believe.what is the best way to achieve this dynamically I am assuming to follow below approach. 1. read the xml using SSIS and store in sql server staging table2. read each record and pass it to stored proc (Stored proc will check for the business logic and inserts into multiple tables by checking referential integrity based on the logic). Appreciate your helpThanksPK |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 15:03:30
|
DOn't think records and rows. Think column instead to increase your ability to think set-based.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
kondap
Starting Member
6 Posts |
Posted - 2009-01-19 : 15:28:34
|
| I am using 10 columns and would like to pass 10 cols as parameters to storedproc. |
|
|
|
|
|
|
Import XML data into sql 2005 dynamically