RE: DTS package that imports a CSV file from an URL

#1

Thank you,
Name is always same.
I am using SQl Server 2000. I see only FTP Task in it. No HTTP task. When I
put URL it was asking User Credentials. But in our Org it goes by NT
authentication. I tried by not putting User creditentials still it doesn't
work.

I found this solution on Microsoft site
A Simple Solution for Downloading and Processing Web Dat
http://msdn.microsoft.com/library/de...k/html/DTS.asp

But we need to create a dll in VB6.0.
Is there any other solution for it.

Thanks

--
Siva R cherukupally

"SQL" wrote:

Quote:

You have to get the file by using FTP or HTTP and place it on the local drive
Second step is to process the file
Is the file name always the same?

http://sqlservercode.blogspot.com/

"SivaRCherukupally" wrote:

I need to be able to create a DTS package that imports a CSV file which is
loated at an URL. If I put the URL address in Text file address it brings the
csv file to a local drive. And whe I run it again it bring only local file
and doesnot bring new file from the URL

Please help point me to anywhere that I can find some help in doing this?
If there is a better way please let me know

Thanks
--
Siva R cherukupally

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: DTS package that imports a CSV file from an URL

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

RE: DTS package that imports a CSV file from an URL - 10-10-2005 , 11:36 AM