dbTalk Databases Forums  

DTS and HTML File

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS and HTML File in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sebastien
 
Posts: n/a

Default DTS and HTML File - 02-23-2005 , 07:01 AM






Hello, I want to use a HTML File connexion but I don't know how to configure
this connection. Do you have an example ? Thank's.

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS and HTML File - 02-23-2005 , 03:34 PM






For the file name, just specify the path to the html file.
Something like:
C:\PathTo\WebFile.html
You can test it by opening a spreadsheet in Excel, save the
spreadsheet to HTML. And then use that file for your testing
of the connection.

-Sue

On Wed, 23 Feb 2005 05:01:04 -0800, Sebastien
<Sebastien (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Hello, I want to use a HTML File connexion but I don't know how to configure
this connection. Do you have an example ? Thank's.


Reply With Quote
  #3  
Old   
sebastien
 
Posts: n/a

Default Re: DTS and HTML File - 02-24-2005 , 01:55 AM



Hello,
My prob is "I can't use the HTML File like a database !". I want to read the
HTML File (with a HTML connection) and put the data in a sqlserver table. But
I don't kown how fill the table zone or the query zone from the HTML
connection.


"Sue Hoegemeier" wrote:

Quote:
For the file name, just specify the path to the html file.
Something like:
C:\PathTo\WebFile.html
You can test it by opening a spreadsheet in Excel, save the
spreadsheet to HTML. And then use that file for your testing
of the connection.

-Sue

On Wed, 23 Feb 2005 05:01:04 -0800, Sebastien
Sebastien (AT) discussions (DOT) microsoft.com> wrote:

Hello, I want to use a HTML File connexion but I don't know how to configure
this connection. Do you have an example ? Thank's.



Reply With Quote
  #4  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS and HTML File - 02-24-2005 , 01:06 PM



When you connect to the html file, whether on the internet
or a file location, the transform data task will pick up
tables it recognizes in the page. In the Table/View section
of the source tab, it will pick up and list the valid html
tables it recognizes.
If it doesn't recognize any tables, then without tables
there is nothing to import.

-Sue

On Wed, 23 Feb 2005 23:55:03 -0800, sebastien
<sebastien (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Hello,
My prob is "I can't use the HTML File like a database !". I want to read the
HTML File (with a HTML connection) and put the data in a sqlserver table. But
I don't kown how fill the table zone or the query zone from the HTML
connection.


"Sue Hoegemeier" wrote:

For the file name, just specify the path to the html file.
Something like:
C:\PathTo\WebFile.html
You can test it by opening a spreadsheet in Excel, save the
spreadsheet to HTML. And then use that file for your testing
of the connection.

-Sue

On Wed, 23 Feb 2005 05:01:04 -0800, Sebastien
Sebastien (AT) discussions (DOT) microsoft.com> wrote:

Hello, I want to use a HTML File connexion but I don't know how to configure
this connection. Do you have an example ? Thank's.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.