TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Istudent Rana
1.4k
360
85k
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.
Reply
Answers (
1
)
I don´t have access to data base
Pivot table and insert the data into table