Hey, Try setting "MaximumErrorCount" property of your package and control flow item to 1

Hey,

Sorry for the late reply.

As others have posted,

1. Using a derived column component will help (posted by Soumya), wherein you have to replace your double quote qualifiers (") for...

Try below steps,

1. Store table data into a temp table.

2. Truncate table.

3. Drop Clustered Index.

4. Reload data from temp table.

5. Re-create Clustered Index.

Hope it works for you!

Regards,

SMK

--------------------------------------------------------------------------------------

"If you’re not prepared...

Hey, I'm glad that worked for you too......!!;-)

Thats the simplicity of SSIS to handle the complexity of data !!!!!!:hehe:

Cheers!

Sunil

Hey, Do you have incoming records in the following format,

column1,column2,column3,........columnN

"abc1","xyz1",10001,...........,"pqr1"

"abc2","xyz2",10002,...........,"pqr2"

.....

Then no worries, in your Flat file connection manager you have something called Qualifier, make use of it. In place of...

Thank you very much for all your replies. This morning I am glad to see so many replies to my post. Thanks Guys!

@Welsh – I tried using format file, the...

Exactly, I could later manage to reorder for PK index. And I did this only because i got a error while moving.

But, what for Non-Clustered Composite Index? I din't get...