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 |
|
boudake
Starting Member
3 Posts |
 Posted - 2015-04-14 : 11:17:55
|
| Hello,I am a new SSIS user et I wanted a solution for this probleme:U have two .csv files which have data tablesIn the X.csv there are two column (ID, Nom)in the Y.csv there are three columns (ID, Nom,Entreprise)Now what I want to do is to select all the data from file X unless data which have Name in file Yin SQL we haveselect X.id, Y.nom, entreprise from X, Y where X.nom not in (select nom from Y)How can I do it?Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2015-04-14 : 12:29:26
|
You will need two connection managers, and two flat file connections.Then use ole db data source to get the data. In the data flow, use LOOKUP component to match the two flows.Use the ouput for "No match".
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
boudake
Starting Member
3 Posts |
Posted - 2015-04-14 : 17:05:21
|
| Thanks very much SwePeso. |
|
|
|
|
|
|
|
|
SSIS solution