Data Migration

• bkoilraj

  Grasshopper

  Points: 21

  More actions

  July 22, 2010 at 1:10 pm

  #142116

  Hi guys,

  Hope u guys help me.

  Actuall I want to migrate from Access Database to SQL Server which has better structured table.

  Suggest me a solution to do the following.

  I have source table as follows

  Employee No | Fever | Cold | Head Ache

  ---------------------------------------

  1 | True |Null|Null

  2 | Null| True Null

  ==========================

  Destination table

  Reference Table:

  ReasonId | Reason

  1 Fever

  2 cold

  3 headache

  Destination table

  Employee_No |Reason Id

  ------------------------

  1 1

  2 2

  How to achieve this through SSIS? My problem is how to check whether the Employee has fever or not?

  IF he has fever then i need to insert into new table. Hope u guys understood.

  Please suggest a way

• bkoilraj

  Grasshopper

  Points: 21

  More actions

  July 25, 2010 at 10:16 pm

  #1197993

  Hi All,

  I have found my self an answer for this problem.

  I used Unpivot transformation. It solved my problem.

  Please refer :

  http://dbantics.blogspot.com/2009/07/unpivot-transformation-with-multiple.html

  Thanks.

  Bhaskar