MS SQL Integration Services import from flat file
Posted on 2011-03-11
Hi, I am new to SSIS and need some guide lines from experts to achieve the following:
- read flat file from ftp account. / Line by line
- Read certain values from the line, values are on certain positions e.g.
- Value 1, start position 2 till 10,
- Value 2, start from 15 till 20,
- Value 2, start from 34 to 40. And so on.
Then pass values to execute store procedure with parameters,
Repeat the execution of the SP for each line / each time with new parameters values read from file until end of the file.
The task should run every day automatically,
Can anyone draw me some guidelines so I can easily and quickly do it?
Thank you for your help.