Thank you ....But even i tried out with a new package ...it says the same thing.

One thing does this Isolation level needs to be changed from default...does this help me...

Yes package won't let me change the stuff... I am struck with this since 3 days ...When i want to change the Transactionoption on PAckagescope to Required from support,...

But to chage the packageScope TransactionOption to required, I need to disable the check point property SaveCheckpoints : False, other wise it doesn't allow me to change from supported to...

Here you go... please see attachements

Thank you for working on this

Thats what exactly I am doing ....but its not working.

One more time for you, I followed your suggestion and this is, what it happens:

1.Initially Failing task, which is outside the...

one container and one task ( script ) outside the container. Check points are enabled on container and Script task. Am I clear???...let me know

Thanku for ur reply ....Yes, I am following all the things that are neccessary for Check points to work at the package level and at the task level in...

Its a simple script task ....which has nothing in it.

Yes ..task AB was taken care of to use checkpoint file ...I mean check point properties for the task (AB)level are assigned to it, so that this has to start...

Thank you for your reply.....

I think i was not clear to u.... Have one container1 ( task1(required), task2(required), task3(required) )on designer ( Supported). This works fine and I can understand...

nope...using a query where in, creating Table variable

Thank you for the reply...

Are you saying to load all the flat files names to Table and then compare it with xxyy table and then (if not matched)...

but how can my program figure it, if there is next avaliable file (say a.2)... And more over in some cases i may get files without order(a.1,a.2,a.4,a.6) Here i should...

Hello Jeffrey Williams-493691,

Actually I am waiting for your reply, Can you help me with my Store proc ( the one I mentioned you above) i can send you the proc...

Thank you all for writing reply appreciate it...

Now i have a business rule, where it has to load file in order. i will try to explain what exactly i...