Can we get text file directly from URL to SQL- DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Can we get text file directly from URL to SQL- DTS

Hey guys, I need to get a text file automatically fromHTTP:// site
using DTS and then i need to DTS transformation. Can we do it by ActiveX script. If we can, what function in vb script i should use?
Have you searched or referred under VB forums for information. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>