PhysicalApplicationPath in a DTS script task

Hello,

What can i use to retrieve the physical application path in a dts script task ?

with asp.net it is request.PhysicalApplicationPath

Thanks a lot

[157 byte] By [Coroebus] at [2008-3-1]

«« how to sync with datagridview columns and object properties
»» Modify the output of the Crystal Report to show 10 pages at a time ?

# 1

Hi there,

Can you describe what you want to do? Obviously, SSIS doesn't execute in the context of HTTP, so I'm interested in finding out what you're after. You cannot find out the location where the package was executed from (file system, SQL Server or Package Store).

Typically folks have a variable that specifies a root folder and reference this variable throughout their package using property expressions.

regards,
ash

AshSharma at 2007-9-8 >

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

# 2

Hi,

my problem is i want to execute package on hosted server. When i use your your http download script, it use c:\ to store the file. I'm not sure to have access to this folder.

My project is to import a text file from http in a database.

Thanks for your help !

Coroebus at 2007-9-8 >

# 3

Depends on your script. In the following example, we use a variable for defining the location of the local file name:

http://www.sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

You'll likely want to have another variable called 'RootFolder' on which to concatenate the file name to end up with the file name in the right folder for your server.

regards,
ash

AshSharma 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