Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Website Data Source

Author  Topic 

KTL_DK
Starting Member

15 Posts

Posted - 2003-09-10 : 09:44:37
I'm doing a DTs that should read Data from a Web page, for instance
a web page that have a table . This web page is online (www.site.com\table.asp) , and i pretend to connect to it once a week to extract the data in order to do some inserts in my Database .
Could someone tell me how i do this, i now it's possible because a long time ago i made something similar , but i don't remenber very well.

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-10 : 12:09:13
Why do you keep asking the same questino over and over again?

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29010[/url]
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29028[/url]
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29011[/url]

I really don't think that you are going about this the correct way. I don't think that you should be using DTS for this. If you explain what the requirement is, we might be able to help you come up with a better solution.

Tara
Go to Top of Page

KTL_DK
Starting Member

15 Posts

Posted - 2003-09-10 : 12:24:39
the 3 posts aren't equal, only two of them are equal, so
i think you should focus on the solution , and discuss the central point of my post's
thanks

note: If this is the DTS forum Area, why are you question about the power of DTs's and advising me not to use DTS?!!!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-10 : 12:34:58
Because DTS should be used sparingly. Just because this option is available, doesn't mean that you should use it. Cursors are available in SQL Server, but you shouldn't use them.

Tara
Go to Top of Page
   

- Advertisement -