How to import files via HTTP in SSIS

Hello,

How can I import data into SQL server via http server ?

Thanks

[73 byte] By [Coroebus] at [2008-2-8]

«« Data source for web services
»» Parameterised Query Performance Problem

# 1

Hi,
Is this any use to you: http://www.sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

JamieThomson at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

Yes i saw it, but i'm novice, i don't know how tu use it ...

If someone can help me

Coroebus at 2007-9-8 >

# 3

The code is VB.Net which can be used within a Script Task in your package.
To start, add two variables. Hope fully the names are self-explanatory-

RemoteUri
LocalFileName

Ensure they are type String, and set some suitable values. Add a Script Task, and replace Sub main with Ash's code.

DarrenSQLIS at 2007-9-8 >

# 4

thanks a lot, i'll try it !

Coroebus at 2007-9-8 >

# 5

How can i do to specifiy the path of local file with something like

PhysicalApplicationPath in a DTS script task ?

Coroebus at 2007-9-8 >

# 6

The script references a variable to get the file - Dts.Variables("LocalFileName").Value

Is PhysicalApplicationPath a special path that you expect to be derived? If so what exactly would you expect it to be?

DarrenSQLIS at 2007-9-8 >

# 7

I need to specify where my file will be downloaded. My problem is i execute this on shared sql server...

Thanks

Coroebus at 2007-9-8 >

# 8

So use the variable and supply the folder you need to that variable. You cannot get th path of the package, as the package may not even have a path, and is being hosted at execution time, so the package path is meaningless. You seem to have started another thread so followup there.

DarrenSQLIS at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech