September 6, 2011 at 2:25 am
I have got a sample xml file whose data i need to import into a sql 2005 table. The table is also attached. How do i get all the data to be inserted into the one table using ssis 2005 as i only am able to pick one field at a time? I generated the xsd file using ssis 2005 but it seems its not helping me for my purpose.
September 6, 2011 at 6:40 am
Hate to say it, but this is the Internet, and I'm not about to open a rar file from an unknown source. If you can post it as .txt or some other non-executable file type, it might get more results for you.
You have a couple of options when it comes to importing XML, but they all include defining the map between XML elements and relational tables+columns.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 6, 2011 at 7:15 am
Sorry about that. Attached are the files in a different format.
December 24, 2011 at 12:51 pm
I have removed the attachments for now. The data looked like real account data.
Please confirm this is not real data and you can repost it, but in this time on the Internet, it is completely inappropriate to post any real data from your company on the Internet without permission.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply