November 17, 2002 at 9:25 pm
Can I use a DTS script to download an excel file from a specified location on the company-wide WAN (Intranet) and import certain rows from the excel into a DB table. Is that possible??
Or do i have to use Ole Automation....functions..
Arvind
Arvind
November 18, 2002 at 4:12 am
When you say dwnload, exactly what type of connection and what transfer method. IP thru HTTP or FTP, IP thru share, which type? Any pretty much can be done but there are specific things you have to care for on each.
November 18, 2002 at 9:36 am
After you have the connection, here is an example in how to import range from excel using DTS
http://www.sqldts.com/default.aspx?6,101,243,0,1
Johnny...
November 18, 2002 at 10:45 pm
Yeah...I got the import into DTS part...thats a good one...
But Can i use the DTS in someway to download the excel from the certain location in the intranet...thru HTTP IP.....and then do the rest....
Cheers
Arvind
Arvind
November 19, 2002 at 3:21 pm
Yes, you can using the File Transfer Protocol Task or http://FTP.exe(check BOL for how to use FTP).
Johnny..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply