tags:

views:

4

answers:

0
Q: 

Data Migration - SSIS

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

Table_Source(EmployeeNo,Fever,Cold,HeadAche) - So if a person is having fever the column will be marked as true.

Employee can have multiple reasons.

New tables

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?

Please suggest a way

related questions

Performance difference - Script Task
blank to numeric conversion derived column
Import Excel data to SQL Server
SSIS Lookup component only returns matching rows when using partial mode
Return dataset in dataflow
timestamp in C#
Use SSIS to import binary data in XML file
Error in retrieving data from Excel File
How to get 2 data sources to merge in SSIS?
execute SSIS package
Store Dataset to DTS Variable
About Script Task
Script Task - File Manipulation
SSIS how to split a single record in to two different records?
Script Task - Add Reference Issue
Tool for generating flat files from SQL objects dynamically
SQL Server 2008 - Script Data as Insert Statements from SSIS Package
Lookup Transformation Task
How can we abort the post in ProcessInputRow() event in SQL SSIS Script Component?
Using SSIS to import a CSV File.
What is SSIS order of data transformation component method calls
The version of component "x" is not compatible with this version of the DataFlow.
SQL Server Integration Services SSIS 2005 - How do I see all the rows in a data viewer?
Producing a revenue forecast in SQL
SSIS - Change Null columns to empty strings