dbTalk Databases Forums  

DTS to import data from web page

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts DTS to import data from web page

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


Discuss DTS to import data from web page in the microsoft.public.sqlserver.dts forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM





Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #12  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM





Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #13  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM


Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #14  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM


Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #15  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM


Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #16  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM


Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
  #17  
Old   
matt
 
Posts: n/a

Default Re: DTS to import data from web page - 03-06-2008 , 01:05 PM


Yes, It's a .txt and a .xls file.


"Sean McCown" <SeanMcCown (AT) discussions (DOT) microsoft.com> wrote

Quote:
Y, sorry dude... you may be sunk on this one. If they can post it as a
.txt
for you instead, or even as well, then you can pull the file down somehow
maybe.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant - http://dbarant.blogspot.com




"bwallacejr" wrote:

One of our business partners provides us with product price and
inventory via a web page. To manually access this data we go to:

http://website.com.com/ecom/inventor...567&pwd=999777

The information then appears as

item_no price map_price qty_available qty_bo qty_in_transit
000-40803-0BI-XX 1.14 0 30 0 0
000-TT106-1ZZ 18.49 0 10 0 0
.....

I currently manually save this page as a .txt file and then import
the data using a DTS

I'd like to create a DTS to automate the entire process. Is this
possible?

I tried toI use DTS to create the connection (using HTML File as the
source) and I get the message:

Error Source: Microsoft Jet Database Engine
Error Description: Cannot Update. Database is read-only



Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top