I have successfully saved DTS packages as .bas files, imported them into my .adp and run then to import .xls data into SQL Server.
This way i can also change the source files etc within the code.
However, when i save a '.txt file to SqlServer' Package and use it in the same way ... nothing...
I was using data islands because i'd seen them mentioned around and thought i'd try them ... see what they had to offer.
Impressed with the easy of displaying data, saves a lot of coding.
That's where the benefits seem to stop for me so far.
Before XML, i would import my data via delimated...
k,
I have a Data Island.
Each record is displayed in table format, with 1 record taking up 2 rows.
Col1 Col2 Col3
Row1 R1 F1 R1 F2 Nested Sub-Table
Row2 R1 F3 R1 F4 ""
-----------
Row3 R2 F1 R2 F2 Nested Sub-Table...
tsuji,
i may have found the problem (though still no idea how to solve).
When the .htc function is called... i changed the script to :
x = document.childNodes;
alert("xo: " + x[0].outerHTML);
.. and this reveals the HTML of the .htc file, NOT the document of the iframe.
I guess this take it...
full source files :
www.outofthebluesolutions.co.uk/xmlTests/sources.zip
the working copy:
www.outofthebluesolutions.co.uk/xmlTests/indexXML2.htm
Notes:
>to see error: click on any node in the left iframe to trigger an alert showing the outerHTML of the iframe body.
File: indexXML2.htm ...
thanks, but i think that's making things worse ?
I've written the writing lines below with comments but basically your changes removed any xsl influence over the output.
(shortened the object names names for ease)
line [2] is the original
lines [3&4] the new ammended
(rem as appropriate)
1]...
okay, so i'll try and keep it succinct !
I have a page, and in the page there is an iframe 'f1'.
Some code wanders off and gets one of these :
- req_catXML = new ActiveXObject("Microsoft.XMLDOM")
and loads 'stream.xlm' for my XML object, and another
- req_catXSL new...
thanks for that (sorry for delay!).
Think this calls for a re-working of my solution so will try with new thread as very different !
Hope you don't mind ..after you effort in replying, but to cut a long story short i think i'm going up the wrong avenue here !!
Regards
Where in reader1.asp, you see 'xmlSample.xml' on line 3, i changed this to 'dynamicXML.asp'.
SO instead of loading a static xml file, i wanted to load the dynamic xml output of 'dynamicXML.ap'
Does that help ?
k, so I was retrieving a standard xml file with the ASP code in 'reader.asp' (below) .. works fine.
Then instead of having a fixed xml file, i wanted to generate the xml from another .asp script, so I created 'dynamicXML.asp' (also below) to generate xml.
When i view 'dynamicXML.asp' direclty...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.