Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

SSIS Insert/Update rows

I've managed to get an Insert working just fine, but couldn't manage to get an Update working in IS. Any ideas on what I need to consider for that?

I managed to get it all working using a Slowly Changing Dimension, but I've been reading that it's a bad object to be using and should be avoided.

Can someone help please?
InsertOnly.JPG
InsertUpdate-SCD.JPG
0
PeterErhard
Asked:
PeterErhard
  • 4
  • 2
1 Solution
 
Pratima PharandeCommented:
I have one suggetion here that I have used in my Poject
Use Lookup to differntiate between insert and update
In Lookupp add the cindition to check in database whether that record exists or not.
If record not exits it will move on Red Line , add insert logic here
If record exists it will move on green line , add updatelogic here

0
 
Pratima PharandeCommented:
see image
Insertuodate.JPG
0
 
PeterErhardAuthor Commented:
Thanks for that.

>>In Lookupp add the cindition to check in database whether that record exists or not.

How do I do this? Could you provide a screen print and a bit of explanation please?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Pratima PharandeCommented:
Right click on Lookup control
Look up Transformation Ediotor will open
then in first tab Reference table select the table or view OR query
then in Second table do the mapping in available columns and Look columns
If that combination is present in table it will go for Green like ..Update
Else REd-Insert

see attached screens
lookup1.JPG
lookup.JPG
0
 
PeterErhardAuthor Commented:
ok thanks, will give it a try.

Have you ever tried these custom components btw?

http://www.sqlbi.eu/Projects/TableDifference/tabid/74/language/en-US/Default.aspx as well?

http://www.codeplex.com/kimballscd
0
 
Pratima PharandeCommented:
I havn't tried it but when I get time I will definaltly like to try it.

thanks for the Links
0
 
PedroCGDCommented:
I haven't tried it before... I'll also take a look and post it in my blog!
Good links..
Regards,
Pedro
www.pedrocgd.blogspot.com
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now