Import CSV file from a URL

#1

I am using SQL Server 2005 and trying to import a CSV file on the web. I am
not a programmer so I was just trying to use the import and export wizard but
don't see any sort of option to pull from a URL. I want to be able to
automate this task so downloading it everytime to a folder manually doesn't
make sense. Any suggestions that a non-programmer like myself could do and
still have it automated?

Thank you!

--
Message posted via http://www.sqlmonster.com

#2

I don't know if this is too "programmer" ish or not, but it shows how I did
it step by step! If you know SSIS enough, you should be able to do it.

http://sqlblogcasts.com/blogs/greenm...-csv-file.aspx

Keith

"RedGlow06 via SQLMonster.com" wrote:

Quote:

I am using SQL Server 2005 and trying to import a CSV file on the web. I am
not a programmer so I was just trying to use the import and export wizard but
don't see any sort of option to pull from a URL. I want to be able to
automate this task so downloading it everytime to a folder manually doesn't
make sense. Any suggestions that a non-programmer like myself could do and
still have it automated?

Thank you!

--
Message posted via http://www.sqlmonster.com

.

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

Import CSV file from a URL

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

Import CSV file from a URL - 02-11-2010 , 03:25 PM

RE: Import CSV file from a URL - 03-19-2010 , 04:05 PM