SCD question

Hot Topic

Rounding error when summing 4 numbers to 0
"Report is being generated" but never does...
Cannot use credentials for proxy account
Errors after startup
Running a profile trace in the background
LinkTarget
BACKUP CERTIFICATE alters ACLs on created file
Auto Updates for SQL Server?
Connecting To Oracle DB (connection error)
Job scheduling for Packages in SQL Server 2005

SQL Server

table scalar function syntax. . how wrong and how far am i?
Group by on a concatenate field
SQL Express Cannot Start
Nested XML with XML Explicit
UNION statement that works in SQL server but not access
Suggested Hardware spec
adventureworks attach error
Deployment File System installation
SQl Mobile for standalone Apps?
Not available in Object Explorer

SCD question

Hi All,

I am new to SSIS and have one question about SCD and its limitations.

I am trying to update / insert a table based on 2 other external columns. I have done my lookups to transform and grab the necessary columns and have a final dataset ready for insertion/updates.

So at this point I was hoping to use SCD to do my updates/inserts based on the criteria that I was given but the only problem is that 2 columns that are necessary to determine if the row should be updated or inserted do not exist in the target table. Is there a way around this or can someone show me another method to achieve my goal


Thanks,
Cheston

Answer this question

SCD question

  • Bipin George Mathew

    Sorry Phil, i'm new and forgive my 'nubness'.

    Yes, I have all the columns in a data flow.

    How do I determine if a column within a row not a key column value has been updated Do I have to do another lookup to get 2 copies of each row and within the conditional split compare each and every one of them

    Thanks,
    Cheston

  • ga2006

    Well, you have all of your columns in the data flow, correct

    In your conditional split transformation you can do equality checking (or whatever parameters you need) such that:

    UpdateFlow: inputTable.column1 == lookupTable.column1 && inputTable.column2 == lookupTable.column2

    Set the default output name to InsertFlow. Then, simply drag the UpdateFlow to an OLEDB Command transformation and the InsertFlow to an OLE DB Destination to insert the records.


  • Kothai Ramesh kumar

    You might want to make your own "SCD" by using a conditional split transformation. Evaluate your two columns and based on which case evaluates, you can go down an update path, or an insert path.


  • pmeinl

    cheston wrote:
    Sorry Phil, i'm new and forgive my 'nubness'.

    Yes, I have all the columns in a data flow.

    How do I determine if a column within a row not a key column value has been updated Do I have to do another lookup to get 2 copies of each row and within the conditional split compare each and every one of them

    Thanks,
    Cheston


    Please read the first post on the main page of this forum... If a record exists update else insert. That should clarify a few things.


  • Steve - B3

    thanks for the quick response. would it be possible to show me how to do this or point me to a reference to read up on how

    Thanks
    Cheston
  • SCD question
Answer this question