no option to remove duplicates?

I have been sending them to a DATA READER DESTINATION COMPONENT...It not failing...

but i am sure that its is using some of the memory inside....i just wanna put them...

Thanks Phil..It works now

Well the input is like this:

Test ok on my box as

006708

A26708

CB6708

026708

006708

K06708

AB6708

And the output should be like this:

6708

A26708

CB6708

26708

6708

K06708

AB6708

Hope it's clear?

I don't want to remove characters from the start....

if it starts with a char leave it as it is....

Only if it starts with 0 trim the zeros

Thanks

you should create a new project and uncheck to check boxes that comes to -CREATE DIRECTORY FOR SOLUTION.

Then you shud add your packages and try working on it...I think it...

Triggers been expensive...Can anyone tell me any other way to do this..I got from some forum that we can use CHECKSUM function or CHECKSUM transformation for this...

Have anyone got any...

Thanks man for the prompt response...let me try dis...

Thanks......I don't know how trigger will help me to track every column...

will it insert a new row for every column changed in a row?

I mena if address and location both...

Thank si got it...:)

any help plzzzzzz

I think in place of deleting you can move the file thru control flow and load to a fresh file...

Hi..

you need to go to the Configure Error output button on lookup Tx and say redirect row in the first row only...then you will get a red arrow down that...

I am using a T-SQL to Disable the job ...If I refresh the JOB MONITOR it show the Enabled = NO But still it recurrs the job...Dont know what is...

Well . suppose my first data flow task is also having a condition before running it...

Like if variable = 'AB' run Data flow task 1...

So where will I put...