SSIS FTP Component ... LocalPath settings ... User::LocalFolderPath

Question

SSIS FTP Component ... LocalPath settings ... User::LocalFolderPath

allan.ford17

SSC Eights!

Points: 944
More actions
March 24, 2019 at 5:57 pm

#383228

Dear Forum,
I am supporting an SSIS process that uses the FTP Component.
The FTP component has a LocalPath setting value of "User::LocalFolderPath"
I am wondering : how does this work? How and what does this value resolve to ?
Any comments much appreciated !
kind regards,
Allan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

allan.ford17 SSC Eights! Points: 944 More actions · Answer 1

I found some help here on viewing with and working with SSIS user variables.

i.e. see:
https://docs.microsoft.com/en-us/sql/integration-services/add-delete-change-scope-of-user-defined-variable-in-a-package?view=sql-server-2014

especially this step:
On the SSIS menu, click Variables. You can optionally display the Variables window by mapping the View.Variables command to a key combination of your choosing on the Keyboard page of the Options dialog box.

All good now .. am understanding this now.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

Thanks for posting what you found, Allan.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)