Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Split

Status
Not open for further replies.
IAMINFO

IAMINFO

MIS
Feb 21, 2002
62
US
Hello everyone I am using SSIS 2005 I have a conditional split component with the error output set as BADNUM and I defined the condition as LEN(number)> 7

I am trying to redirect rows that have more than 7 digits in the number_column to an error database. Please help if you can,am I using the correct expression? Thank you for reading this post
 
Sort by date Sort by votes
Thank you for reading I have figured it out , my data was going out the default pipe. I have corrected the problem
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ChrisMarin
  • Locked
  • Question
Multiple Rows, split order when items total 720g
Replies
2
Views
89
gk53
gk53
Broadleon
  • Locked
  • Question
SSIS Derived Column split first parentheses of characters
Replies
1
Views
99
fredericofonseca
fredericofonseca
sparkbyte
  • Locked
  • Question
Split Contact Names
Replies
0
Views
43
sparkbyte
sparkbyte
ChrisMarin
  • Locked
  • Question
Flat file source - split delimited address field to additional fields.
Replies
1
Views
75
fredericofonseca
fredericofonseca
nubianwarrior
  • Locked
  • Question
create derived column using multiple conditional operators
Replies
3
Views
69
MDXer
MDXer

Part and Inventory Search

Sponsor

Back
Top