how to load two flat files data into single sqlserver table?

Hi All,

I have requirement like,I have two falt files which contains one column each.Now I have to load the files data into sqlserver table which should contains two columns.

Ex:FlatFile1-->SID

FaltFile2-->SName

Table-->SID  SName

Table should contain two columns as shown above without Null values.

Can some one help me on this ASAp,Since it was urgent task for me.

Regards,

February 25th, 2014 2:30am

Is that possible you have SID and do not  SName and opposite? 
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2014 4:16am

How do you determine which SID value has to be merged with which SNAme value from both the files?
February 25th, 2014 4:22am

It is possible if you have a relationship between the two files 

you can use a merge join to do this 

please refer : https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-merge-join-transformation/

Free Windows Admin Tool Kit Click here and download it now
February 25th, 2014 9:15am

Hi,

Thanks all for your replies.Here I don't have any relation between two files,I have tried using merge join,i was able to get two columns but getting null values.

Regards,

Sudha

February 26th, 2014 4:40am

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

Other recent topics Other recent topics