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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-09-24 : 11:58:04
|
| Hi,I need to design SSIS package for xml file importing to tablewhat component i should use to read xml file and put this into DB tablealso what syntax i used if i used component SQL Script and how to check if file is exists in that folder or not...if yes take it and read and then insert record from it to DB table.Please help me outT.I.A |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 12:06:48
|
| xml file can be read using XML Source and you need OLEDB destination task to put it into table.The existence of file can be checked using Script task and use conditioanl task to insert data only if it exists or use ForEachLoop with file enumerator to look for files in particular folder. |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-09-25 : 03:33:03
|
| ohhhThanks Again!!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 04:18:44
|
welcome  |
|
|
|
|
|
|
Read xml file if exists and import into DB table