Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data exists Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 9:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
hi

ia m getting data from 2 excel file ,that i need to merge and then load into destination table.

but before file load i need to 1 number from 1 file, if it is already exists in the database, i dont need to insert that rows,if not i need to insert

hwo to do using ssis
Post #1382057
Posted Wednesday, November 7, 2012 12:11 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
If you have some sort of ID column, use a lookup transform to lookup data that is already in your table and match it to the data coming in from Excel. Configure the lookup transform to ignore errors and then use the No Match precedence constraint to connect to your destination table.
Post #1382121
Posted Thursday, November 8, 2012 8:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
ok.

can i check in lookup with 2 column

for example productid and productname both should match .not OR.

Post #1382532
Posted Thursday, November 8, 2012 10:22 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:36 AM
Points: 4,985, Visits: 11,681
Yes.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1382616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse