I have the records in my flat file as below :

HDR123495968908

1111023456712345

1234567890098007

TRL4567897593494

After the use of derived column I am able to map certain characters to the particular column of database table.

Now...

I used an Expression

IsNull(SUBSTRING([column 0],8,1))?"a":[column 0]

but it's not working .

Is this expression checks whole string for null value or only particlar character.

Plz help for this.....................

Thanks,

I tried it & it's working .

I also have to check a particular character at an index no. 8 is blank/null/not specified .

If character is not present there then I...

My Flat file (.txt) is in followong format :

1000034567

1000089564

1000034216

1000024076

.

.

.

.

.

The file Contains too many records.

I have to put first 5 characters(digits) into "Code" column of "dbo.Device"

I also have to put...

Will you plz give me some examples to do in a way you suggested .

That will be really helpful to me ...

Thanks.....

Thanks,

I tried in a way suggested but I want to map certain length of characters to certain columns in table from each record . because the file contains the...