Avatar of Kongta
KongtaFlag for Switzerland

asked on 

SSIS import

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
rgds
Kongta
Microsoft SQL ServerSSIS

Avatar of undefined
Last Comment
Kongta
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Kongta
Kongta
Flag of Switzerland image

ASKER

just googled the Pivot and got some results as YouTube-Videos, think that might be the way. let me try. thx a lot, rgds
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo