Have you tried with changing the datatype try using nchar instead of char. This may work use nchar(255) a bigger value.

The error message is saying that string or Binary value would have been Truncate means you are trying to insert a value which has more length you defined so you...

You can do some thing like this

select * into TempTable

from OldTable

-- Here you can use a where condition to get only the records you wanted.

--or you can delete the records...

Declare a newvariable called Filename and in the expression builder use the below expression it will give you fileName

REVERSE(SUBSTRING(

...

Thanks guys for your reply. I am sorry for the broken DDL

Here is the correct Table structure ans some sample Data

Create table Customersnumber

(

cityname varchar(25)

,LoyalCustomers int

,DiscountCustomers int

,ImpulseCustomers int

,NeedBasedCustomers int

,WanderingCustomers int

)

insert...

Thanks a lot for your help. Struggled for a day with this. But looks very simple and clear.

finally i solved this by changing Text qualifier: " in the flat file connection manager

ya got it!! Thanks for the Query again

Thanks guys for your query

i have executed this and it gave me all the table names and columns where the condition is met.

Here all my datatypes are varchar there is no other datatype i have loaded the data into stating table where i have got some negative values and empty spaces loaded...

Thanks for the reply, I think this update statement is only for updating a particular column but i have to update all of my columns, tables in my entire Database,...

I am assuming that you are doing other things with these file and not just moving them?

If not, the FEL is overkill (and potentially slow). Instead you could use Execute...