CODEWITHSUNDEEP
sql-serverssisssis-2008
Vignesh Kiswanth
Vignesh Kiswanth

Reputation: 101

How to pass result of Conditional Split to variable?

I have a flat file and used conditional split to filter the record into a single row. For example, RecordType == "2" retrieves single row with record having multiple columns say A,B,C,D and E. I want to pass the result of Column C value to a variable. And then to use it to update the table like:

Update tablename Set A = that variable Where A is null

Could you please help me in find out the solution.

Upvotes: 0

Views: 290

Answers (1)

KeithL
KeithL

Reputation: 5594

I would not use the variable but use a Ole DB Command object.

You set the connection.

Then add your SQL from above: Update tablename Set A = ? Where A is null

The map to Col C.

However, what I might guess you are trying to do is add a column to your other record set that has the detail but no key.

I would use a script component to do this:

Similar to this example: Importing Grouped Report Data to Database

Upvotes: 1

Related Questions