본문 바로가기
Microsoft BI

How to use SFTP by WinSCP

1. access https://winscp.net

 

2. Click! [Installation package]

 

3. You can download setup file

 

4. Install

 

5. Proceed with the installation

 

--------------------------------------------------------------------------------------------------------------------------

.Net assembly

 

1.  You can look "WinSCPnet.dll" after you install WinSCP above.

 

2. Run the following code

 

 

--------------------------------------------------------------------------------------------------------------------------

Development SSIS

 

1.  You can look "WinSCPnet.dll" after you install WinSCP above.

 

2. Click "Variables" on new small window after mouse right click at anywhere 

 

3. Make Variables value by your SFTP information

 

4. Click small icon after double click [Script Task Editor]

   And, Select Variables that you made previous

 

5. Click [Edit Script]

 

6. Add WinSCPnet.dll into "Reference" (The dll file location = C:\Program Files (x86)\WinSCP )

 

7. Add below code into Main() method.

 

 

'Microsoft BI' 카테고리의 다른 글

성능 향상을 위한 SQL 작성법  (0) 2017.03.17
SQL Trace (Save to file)  (0) 2016.10.25
Configuring HTTP Access for Analysis Services(Tabular model)  (0) 2016.09.17
Clear the Analysis Data Caches  (0) 2016.09.16
Tabular Display Folders  (0) 2016.09.16