Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2014-06-05 : 02:47:27
|
| I have two sources one targetSource one accessdb fileSource two csv file with only one value Y or N and nothing elseI want to load the data to target table, from accessdb file, but before loading I need to check the csv file content IF Y then filter data from accessdb file by adding "where accessdb.Entry='PCO' IF csv Content is N then filter data from accessdb file by adding "where accessdb.Entry<>'PCO'can anyone of you help me with the logic, have all the setup for getting accessdb data to target table just need to add the csv comparison.-Neil |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2014-06-05 : 09:40:41
|
| any idea how to compare the incoming data from flat file against the accessdb incoming data, to populate the target table, just logic will also do-Neil |
 |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2014-06-05 : 13:37:17
|
| The incoming data from flat file has only one record value either as Y or N. right now I am capturing this into variable just need to filter the incoming data from accessdb file based on csv content Y or NIf Y(in csv) I need to filter the accessdb data on one of its column say Where Entry = 'YES' only load this data and ignore otherIf N(in csv) then Entry = 'NO' only load this data and ignore other-Neil |
|
|
|
|
|
|
Loading data from 2 sources and filtering it befor