conditional split issue - basic package

Question

conditional split issue - basic package

justintime

Ten Centuries

Points: 1060
More actions
May 25, 2010 at 2:12 pm

#221454

SSIS 2005
i am trying to produce a simple excel file for each property that we manage. i would like to take information from each building and export to their own excel file.
i am having trouble getting my first attempt at using conditional split to work. here is my data flow sequence.
- ole db source
- data conversion since my destination is multiple excel files. i received unicode/non-unicode conversion errors before i added this data conversion transformation. i get no errors on this transformation. that part seems fine.
- conditional split under data conversion.
- several excel file destinations. one for each building.
in my conditional split dialog i have:
Order Output name Condition
1 building 001 bl_id=="001"
1 building 002 bl_id=="002"
1 building 003 bl_id=="003"
if i run the package like this, nothing happens. i get no errors. i can see that all rows are moving from the source to the data conversion, and all rows are passing correctly through the data conversion to the conditional split. no rows are being redirected to the appropriate excel destinations. i have a connection manager set up for each of the excel files; one for each building. the files already exist and are blank except for the header.
if i add a new excel destination, then all rows go to that new destination. is there something in my syntax that is not telling the split to do what i am intending? do i need to change the order of my transformations or add something else in there so that the conditional split works.
thanks in advance for any assistance here
-js
May 26, 2010 at 6:13 am

This was removed by the editor as SPAM
May 27, 2010 at 11:43 pm

This was removed by the editor as SPAM
May 27, 2010 at 11:46 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Shouldn't the order by 1,2,3, instead of 1,1,1?

I think that if you give them all the same order, they are evaluated at the same time, and of course no row matches all constraints.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

justintime Ten Centuries Points: 1060 More actions · Answer 2

thanks for the responses. i tried another route, just to see if i can get it to write to different tables, as opposed to different excel files. i get the same result. all rows go to the default output. all tables are in the same db.

1. i have a sql source

2. then the conditional split where i am using:

1 Case 001 bl_id == "001"

2 Case 002 bl_id == "002"

3 Case 003 bl_id == "003"

3. after the split i have 4 destinations set up. one for a table to house bl 001, one for bl 002, one for bl 003, and one for the rest (default output).

all data goes through the split straight to the default output table.

all datatypes are the same. what gives?

justintime Ten Centuries Points: 1060 More actions · Answer 3

trim did it! gotta give it to you on that one. thanks a ton.