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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS solution

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 tables

In 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 Y

in SQL we have

select 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
Go to Top of Page

boudake
Starting Member

3 Posts

Posted - 2015-04-14 : 17:05:21
Thanks very much SwePeso.
Go to Top of Page
   

- Advertisement -