Click here to Skip to main content
15,888,113 members
Search within:


how to count number of digits in a numeric value in SSIS?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SSIS
i have to validate a numeric value while importing data, the number should consist exactly 9 digits. i need to place a record with null or invalid data(number of less than 9 digits) into a flat file. how do i write a condition for it in conditional split?



1. "123456789 "---> valid data
2. "4564"--->invalid
3. "" --->invalid
any help is appreciated.... :)
thanks in advance
Posted
Updated 13-Oct-11 1:49am
v2
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Program reads number of digits
C program that counts how many digits a number have
Arithmetic overflow error converting numeric to data type numeric.
Segmentation fault on frequency of digits in a string count in C
number must be numeric up to 9 digits
how to insert 4 digits numeric in sql with increment
Assign a expression SQL result to a variable in SSIS
Coding challenge: count the one bits in a number.
How to change 9 digit uploaded data into 10-digit number in angular
count the number of characters in a string

Advertise
Privacy
Cookies
Terms of Use
Last Updated 13 Oct 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900