 | |
DTS to import data from web page
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS to import data from web page -
01-29-2008
, 09:44 AM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
#7
| |||
| |||
|
|
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 |
#8
| |||
| |||
|
|
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 |
#9
| |||
| |||
|
|
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 |
#10
| |||
| |||
|
|
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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.