ssis derived column expression

I'm trying to concatenate with zero incase length of column is < 8  but looks like some syntax error in SIS derived column . Carnumber already a string which is converted in prior data conversion task .

LEN(Data Conversion.carNumber) <8 ?    "0" + Data Conversion.carNumber : Data Conversion.carNumber
learner0824Asked:
Who is Participating?
 
DcpKingCommented:
You may need brackets around the name - [Data Conversion].carNumber. However, what's the SSIS error you're getting?

Mike
0
 
Rainer JeschorCommented:
Hi,
I am not sure if your column name is really Data Conversion.carNumber?

Nevertheless, you have to encapsulate column names with whitespaces into square brackets:
LEN([Data Conversion.carNumber]) < 8 ? "0" + [Data Conversion.carNumber] : [Data Conversion.carNumber]

Open in new window


HTH
Rainer
0
 
learner0824Author Commented:
well I had data conversion in the flow before dervied column. Thats why you have that [data conversion].carnumber column.
0
 
Rainer JeschorCommented:
Hi,
could you perhaps upload the package?
(please rename the file to dtsx.txt otherwise it couod not be uploaded)
Thanks
Rainer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.