Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import data from excel and load into sql server Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 1:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 30, 2014 1:04 PM
Points: 26, Visits: 340
I need to import data from excel and excel has data like this for example
Column Name
Test01 test02 test03 test04 test05
Values
State2_J State4_A State2_H NUll NULL

State3_a State1_A State3_F NULL State4_P


In requirment all this data value become distinct column value like this

State2_A, State2_B,State2_J,State4_A


So i need to yes under appropriate column name and rest remain null for example

State2_A, State2_B,State2_J,State4_A
yes YES

Please Help me. any idea would be apericated.
Post #1341507
Posted Tuesday, August 7, 2012 7:13 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
Are you using SSIS for your ETL purposes?

Regards:
Mordred
Keep on Coding in the Free World
Post #1341644
Posted Tuesday, August 7, 2012 8:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,566, Visits: 24,731
Is
Test01 test02 test03 test04 test05
-----------------------------------------------------
State2_J State4_A State2_H NUll NULL

Do columns test04 and test05 contain
a. the charactes null, NULL
b. blank characters
c. EMPTY?


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1341655
Posted Wednesday, August 8, 2012 8:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 30, 2014 1:04 PM
Points: 26, Visits: 340
Yes!!! I am using SSIS
Post #1341899
Posted Wednesday, August 8, 2012 8:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 30, 2014 1:04 PM
Points: 26, Visits: 340
I have many other column, in which i dont have any value that's why i specify null. As I mention earlier my data value are becoming column and we have to put "Yes" under apropriate column name.
Post #1341902
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse