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...
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...
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...
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.