how to perform multiple database taks using conditional split

Question

how to perform multiple database taks using conditional split

jagadeeshb

Right there with Babe

Points: 782
More actions
January 9, 2010 at 9:46 pm

#386068

Hi,
Here i want to insert the records in table1 and update the records if exists in the same table1. Here i am using conditional split to perform this but i am unable to update the existing records? what is the problem? Is my analysis is wrong?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

We need to ask what is the problem, since we cannot see what is the error you are getting (if you are getting one).

You need to look at the article in my signature and post the DDL, and sample data and also show what is that you already have tried, and only then it would be possible to figure out what's wrong.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

jagadeeshb Right there with Babe Points: 782 More actions · Answer 2

Hi,

Here i am not getting any error just the query is executing but not updating in the database infact it is inserting the duplicate records in that table.

Thanks,

Jags

Phil Parkin SSC Guru Points: 246757 More actions · Answer 3

To perform updates use an OLEDB Command within your dataflow.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.