Link to home
Avatar of fippif
fippif

asked on

How to use join conditions in SSIS?

I am importing some data into SQL 2005 using SSIS. I need to send this data to multiple tables based on several conditions. I like the Conditional Split. But what is the most efficient way to create join conditions? For instance, if I have a script as followed:

...
WHERE field_1 > 0
AND field_2 = "Sunday"

Do I need to use a separate Conditional Split for each one of these conditions? Or is there a more efficient way of approaching this problem?


Thx!
Avatar of nmcdermaid
nmcdermaid

No you just put that entire expression in the conditional split. You don't have to split out field_1>0, then feed it into another conditional split and then split out field_2=sunday.
Avatar of fippif

ASKER

Hmm... I guess I had to use && instead of AND... the following should work then?
(field_1 > 0) && (field_2 = "Sunday")

Thx.
ASKER CERTIFIED SOLUTION
Avatar of nmcdermaid
nmcdermaid

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of fippif

ASKER

Thx!