Retrieve Data from a csv file and assign to a SSIS Variable

Question

Good day! Basically I am importing data from CSV file but would like to assign the value in cell C2 to a variable to be used in the SSIS flow. I know that this can be done using Script Task but I'm no c# person.

Appreciate any help.enter image description here

Where does C# come into this? Why can't you just read the data from the datasource in SSIS? — Rowland Shaw, Nov 08 '16 at 10:34
check this out it might get you going [using Excel with SSIS](https://msdn.microsoft.com/en-us/library/ms403358.aspx) — bilpor, Nov 08 '16 at 11:02

score 1 · Answer 1 · answered Nov 09 '16 at 09:37

1

use record set as destination assign valuues to obj type variable and later using for each loop (for each ADO Enumerator u can assign the values to separate variales)

answered Nov 09 '16 at 09:37

sangeeth sasidharan

117
11

Retrieve Data from a csv file and assign to a SSIS Variable

1 Answers1