export excel table to sql
I have the excel in the following format BU| Jan-10 | Feb-10 | Mar-10 1001 2 3 4 1002 null 1 2 I have an SQL table with following columns BU Month-Yr Count so the end table should contain BU Month Count 1001 Jan-10 2 1001 Feb-10 3 1001 Mar-10 4 1002 Jan-10 null 1002 Feb-10 1 1002 Mar-10 2 Regards, Navin Navin.D http://navind.spaces.live.com/
November 12th, 2010 6:24am

You should be able to use the Unpivot transformation in the dataflow of an SSIS package. An explanation of how to use it can be found here: http://www.mssqltips.com/tip.asp?tip=1761every day is a school day
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 7:08am

Hi Navind, you should use a unpivot transformation to achieve it. Follow these steps: 1.When configure ,mark the columns of months on Avalaible input columns (on top of form). 2.On grid at bottom set a unique value in Destination columns, like 'Count', setting the pivot key value as the name of column (Jan-10, Feb-10, Mar-10) 3. The last step is insert 'Month' in the bottom text box. 4. for debug purposes, add a dataviewer on unpivot output and check this transformation. Hope this help! However tell me if don'tVctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it.
November 12th, 2010 7:10am

You should be able to use the Unpivot transformation in the dataflow of an SSIS package. An explanation of how to use it can be found here: http://www.mssqltips.com/tip.asp?tip=1761 every day is a school day I should write fastest! There isnt answer when post my reply. Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 7:13am

I should write fastest! There isnt answer when post my reply. Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. Ha ha- Victor, if i was typing my answer in Spanish i'd be typing all day!!every day is a school day
November 12th, 2010 7:16am

How to handle null data or empty rows in the excel, as i got no record in mydestination table.Navin.D http://navind.spaces.live.com/
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 5:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics