Istudent Rana

Istudent Rana

  • 1.3k
  • 317
  • 79.7k

SSIS Iterate through file path and load content from file

Apr 29 2019 9:54 PM
I have a text file which has list of path to text files.
c:\product\0001_prodDescription.txt
c:\product\0001_prodDetails.txt
c:\product\0002_prodDescription.txt
c:\product\0002_prodDetails.txt
what i want to do is read through the file and insert product_id, product_description and product_details
in my database table. Description and details text file is plain text about product description and details.
I need to pasrse the path to get id .
How do i do this operation in SSIS?
I am new to SSIS.

Answers (1)