... And the problem is also not mentioned...

David,

Got It !. I had placed "Script Task" outside the "for Each Loop Container". Now I put it inside and it's working fine now.

Thank you somuch.

david.tyler (8/14/2009)

---

Perhaps the is something wrong with the variable. Under the Dim filePath As String = Dts.Variables.Item("FileName").Value.ToString line add msgbox(filePath). Then run the package and see if the process is...

David,

I tried by puting MsgBox(filePath). Infact it is not looping through at all. It popus up only once. Wot am I missing, I don't understand at all. In "Variable Mappings"...

Thanks for your reply.

Yes. I have variable index set to 0. But still it's not moving through files I suppose. Anyways I...

Dear David,

I tried what you have mentioned. It works fine but there is a small problem.It doesn't delete all files. It deletes only a single file.What am I missing. ?

Thanks.

Ratheesh,

Those are records that have been logically deleted but not physically deleted from the leaf level of an index.

By the way wot actualy are you doing in Asianet.?

Regards,

Thanks. To be frank I was not aware about it.

And I have never seen anybody using it as well.

Thank you david.

I will try the same and revert.

Hi,

I had tried it. Was thinking the same way. But it din't work.

Though we can mention the extension, I assume, it might be checking if the file is an SQL...

..And answer is in the subject itself...................

Easy...But important.

Thanks for your quick reply.

I work in SQL Server 2005 and have never worked in SQL Server 2008. Hence I will go ahead with "70-431" exams.

Hope this certification will be...

Sure. I will send it by today evening as am in office now and busy with some urgent work.

Thanks.

Hi Ron,

Kindly let me know if you require people.

I have overall 7 years experience in IT out of which 3 years

as SQL DBA. Am about to get my MCTS...