question

manishacumen avatar image
manishacumen asked

Source file path to be read from Excel sheet rows

Hi, I have an Excel file (Assume Source Path file) that contains the path of the other files. I need to read the path from this Excel & then need to load data from file present on the path to SQL server tables. Any suggestion how to achieve it?
dynamicssis excelsourcevariable
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.