| Author | Message | ||
     Visitor Junior Artist Username: Visitor Post Number: 301 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
bro, I am using this option, however syntax errors emi raavatledhu, but I am not getting any rows out... | ||
| Spy_india Hero Username: Spy_india Post Number: 10828 Registered: 02-2008 Posted From: 172.56.32.44 Rating: N/A |
Thru query insert cheyala ?? Ssis ayite simble XML source hai select columns hai destination server table ki insert hai Hinduism-Saism  | ||
| Sannayi_nokkulu Comedian Username: Sannayi_nokkulu Post Number: 1685 Registered: 06-2014 Posted From: 199.202.216.66 Rating: N/A |
http://support.microsoft.com/kb/316005 | ||
| Legend Username: Twitter Post Number: 37244 Registered: 10-2009 Posted From: 65.190.85.200 Rating: N/A |
another useful link http://www.mssqltips.com/sqlservertip/2899/importing-and-pro cessing-data-from-xml-files-into-sql-server-tables/ | ||
| Visitor Junior Artist Username: Visitor Post Number: 300 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
should be a relational table.. each file represents a power generator.. my table is going to look like this: 'file name a.k.a generator name', measurementDate, updateTime, lineId, origin, terminus, voltage, type, deliveredTime, megawattDelivered | ||
| Legend Username: Twitter Post Number: 37243 Registered: 10-2009 Posted From: 65.190.85.200 Rating: N/A |
oh you are reading xml data and loading as rows ..okk check if this helps http://stackoverflow.com/questions/21378729/how-to-insert-xm l-data-into-sql-server-table | ||
| Visitor Junior Artist Username: Visitor Post Number: 299 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
Main tag TransmissionLineDatafeed.. this has measurementDate and updateTime -> sub tag is TransmissionLine (lineId, origin, terminus, voltage, type) ---> Sub tag to TransmissionLine is Measurement (deliveredTime, megawattDelivered) | ||
| Legend Username: Twitter Post Number: 37242 Registered: 10-2009 Posted From: 65.190.85.200 Rating: N/A |
what is the column type that you are loading this xml into.. a clob or xml or what? | ||
| Visitor Junior Artist Username: Visitor Post Number: 298 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
"<?xml> <transmissionlinedatafeed> <transmissionline> <measurement> <measurement> <measurement> </transmissionline> <transmissionline> <measurement> <measurement> <measurement> <measurement> <measurement> </transmissionline> </transmissionlinedatafeed> " | ||
| Visitor Junior Artist Username: Visitor Post Number: 297 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
hmm, how can I paste the contents here.. | ||
| Visitor Junior Artist Username: Visitor Post Number: 296 Registered: 01-2011 Posted From: 199.168.151.169 Rating: N/A |
Urgent help. XML data ni SQL table loki load cheyyali.. I am only providing small set of data, however there are at least 1000 files and each file has about a million rows. I can iterate through the files and load the data if I can get one file loaded (basic query to load XML to SQL is what I am looking for) See the sample data below: <?xml> <transmissionlinedatafeed> <transmissionline> <measurement> <measurement> <measurement> </transmissionline> <transmissionline> <measurement> <measurement> <measurement> <measurement> <measurement> </transmissionline> </transmissionlinedatafeed> |
