SSIS - Store each column from CSV into rows in table

Question

I need to create an SSIS package to load data from a CSV, the tricky part is some of the columns need to be stored as rows. I better explain it with an example below.

From CSV file to Table in a different format as shown below

Is it possible with in SSIS or using SQL Server.

Dave C · Accepted Answer · 2016-03-01 21:43:55Z

2

What you seek is called unpivot.

Please see this MSDN blog post for an example. To drop 0 values, you can use a conditional split, and push the 0 values to a garbage output.

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2014/05/22/unvipot-transformation-with-a-combination-of-single-and-multiple-destination-columns.aspx

answered Mar 1, 2016 at 21:43

Dave C

7,4821 gold badge21 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MSBI-Geek Over a year ago

Thanks for the reply, this is 90% of what I want. However I also need the flat file columns to be inserted into table, from my above example Oct-15 which a column of flat file should go into the table. If it is going to be difficult I need to ask the sender to adhere to standard set of columns. I'll try unpivot today.

Collectives™ on Stack Overflow

SSIS - Store each column from CSV into rows in table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related