I would like to Import following xls [http://www.imf.org/external/pubs/ft/weo/2015/02/weodata/download.aspx
] into SQL by SSIS. My SQL table should look like
ISO Code year rate
AFG PCPIPCH 2008 26.41
AFG PCPIPCH 2009 -6.81
AFG PCPIPCH 2010 2.17
but the xls has a different listing like
ISO Code 2008 2009 2010 2011
AFG PCPIPCH 26.41 -6.81 2.17 ...
What would be in your view the most efficient way to Import by SSIS?
Shall I go for coding like
INSERT INTO ISO, Code , year (2008), rate
SELECT ISO, Code, 2008....
or something like Looping in SSIS with variables (year) +1?
thx for your Input