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.