Good morning,

I'm trying to create a variable in SSIS to assign dynamically the %TEMP% Windows folder.

I've tried writing %TEMP% directly on the variable but it doesn't works.

Now I'm using a script component to extract and assign the value of %TEMP% to the variable but I'm sure that has to be a easier way to obtain this value.

The VB code that I'm using is the one published by Tim Visee in this article: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1347b1dc-3004-4119-8991-b92abde35016/get-temp-folder-path?forum=vbgeneral

Any suggestions?

Thank you!

In Window 7 you can access the direct folder as,

C:\Users\username\AppData\Local\Temp

Virckof,

GetTempPath() method shud help you ..

string tempPath =    System.IO.Path.GetTempPath();

check:

http://stackoverflow.com/questions/944483/how-to-get-temporary-folder-for-current-user

http://msdn.microsoft.com/en-us/library/system.io.path.gettemppath.aspx

http://social.msdn.microsoft.com/forums/vstudio/en-US/418057a5-3930-4428-854e-9a3e3f276c1b/c-what-pathgettemppath-suppose-return

For VB,

result As String = Path.GetTempPath()
Console.WriteLine(result)

http://msdn.microsoft.com/en-us/library/system.io.path.gettemppath.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-

Hello RSingh(),

You're right, that's the path for Windows 7.

The problem that I'm trying to avoid is that not always the packages are running from the same machine or system. I mean, sometimes my colleague or I can run the packages from our machines and, other times, directly on the server with a scheduled job.

The operating systems are different and the %TEMP% directory too. For that, I'm reading always the system variable to extract the path with the script component.

I would like if there is a simpler way to do this process or the one that I'm currently doing is the simplest one.

Thank you,

Virgilio

Thank you for the method Jayakumaur,

It works perfectly! :)

Still, the I have to embed it on a script component that was the thing that I was trying to avoid.

If nobody knows a way to extract the path without use a script component on the next hours, I'll mark your answer as the answer to my doubt.

Thank you,

Virgilio

Good morning!

Finally I achieved to obtain the value of the environmental variable %TEMP% without using a script component. The steps that I've followed are:

1. Declare a variable of string type on the package that you want to obtain the %TEMP% path.

2. Go to SSIS -> Package Configurations -> Enable package configurations -> Add... -> Configuration Type (Environment Variable) . Here you select the environment variable to use.

3. Go to the next step and select the variables in which this configuration will store the value, in my case the variable that I've created on the step 1.

4. When you run your package, your new variable will have dynamically the path indicated by the %TEMP% variable.

Virgilio

• Marked as answer by Virckof Monday, April 07, 2014 9:21 AM

Very nice! I was glad to find your answer. Really helped!