Compare fields-two flat files-load data

Hi All,

I am totally new to SSIS and im in the learing phase. I have a requirement as below,

I have two flat files (mainframe files), the structure i have given below,

File1:

070113

12345johnk

23456james

1st row is header record which has got date in YYMMDD format and remaining rows have emp no and emp name

File2:

070113

070113

070113

070113

contains 4 records which are dates.

The requirement is to compare the header date in file1 with the 4 dates in file2, if they are equal then it should load all the records in file1 except the header into a table and if they donot match then it should log an err msg. Please could someone provide a lead on this.

The files have same record length and fixed field delimited.

Thanks in advance

raj

Dear SSISQuest,

1. Add 2 flatFile Source

2. Add 2 Sort transform for each FlatFile Source

3. Add Inner Join Transform and do a LEFT JOIN

4. Add SQL Destination or other!

Helped?

regards!