One way would be to create two connection managers for the file. One connection manager has two columns divided by the colon, without a header. You would read this in one data flow that uses a script component to assign the value from the Relative
Date row to one variable and the Run Date to the other. By the way, this is a bit more complicated than this. You will need to assign the values to class level variables and then write the values of the class level variables to the SSIS variables.
Next you need a connection manager that skips the first 3 lines and has column headers. You will use the comma delimitter. Next in your data flow you would add a derived column transformation that adds the two SSIS variables to the flow.
Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com
Marked as answer byEileen ZhaoThursday, February 28, 2013 8:19 AM