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 |
|
cfair_ssis
Starting Member
6 Posts |
 Posted - 2010-04-20 : 11:12:47
|
| I am new to SSIS and have (what I hope) is a simple question. In summary what I have and what I'm trying to accomplish:1. Have an Access db - let's call it 'A' - on a shared network drive and I'm pulling data from one table from this db.2. Have a SQL Server db, let's call it 'B'.3. I want to move the records from A to B, however, I first want to check if the record from A already exists in B. If it already exists in B, I DO NOT want to move it to B.Is this possible to do in SSIS?In general, how would I accomplish this (do I need to use a data flow transformation of some sort)?Thank you in advance,Chuck |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
cfair_ssis
Starting Member
6 Posts |
Posted - 2010-04-20 : 12:29:57
|
| Absolutely fantastic!I knew how I wanted to (and would) do it using SQL (Method 1), but I could not translate it to SSIS. I had all the same steps, except I couldn't figure out how to do the Is Null piece. Handling it in the Conditional Split step was the piece that I was missing!I don't think I would have ever come up with the Method 2 solution. Very cool. Good to know.Thank you very much!Chuck |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-21 : 01:44:05
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
New to SSIS - Access to SQL Server Question