SSIS to load files from two SFTP location.

• SQListic

  SSCertifiable

  Points: 6904

  More actions

  May 18, 2015 at 2:43 pm

  #298168

  Hi How to load files with similar format , from two different locations into same database with same ssis.

  Lets say

  Location 1: C:\LoadFiles\Cust1\APP_123445.txt

  Location 2: D:\LoadFiles\cust2\VDD_543121.txt

  Currently we have one ssis which loads and process files from C:\LoadFiles\Cust1 only. we have to modify the existing package it to load files from Location 2 (D:\LoadFiles\cust2) as well. Also while loading, the ssis should assign a value to existing column CustID depending upon the file name. File names always start with APP_ in first location. VDD_ in second location

  Assign CUSTID as 100 if file name starts with APP_

  Assign CUSTID as 200if file name starts with VDD_

• Almighty

  SSCrazy

  Points: 2001

  More actions

  May 19, 2015 at 5:02 am

  #1798957

  you can use looping feature of SSIS and pass the variable as and when require