Thanks for your reply. I have corrected all those errors but this time I see,

DTS Script Task : Runtime Error

The element cannot be found in a collection. This error happens...

Thanks for the reply but its still not working somehow. It says,

Error: Failed to lock variable "\C:\Shared\jobs\test_20111001.xls" for read access with error 0xC0010001 "The variable cannot be found. This occurs...

Thanks a lot Anil. 2 Questions. Can I use this same code in SQL 2005?? I mean C# 2005??

I tried something in Visual .Net 2005 in main Body

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

Dim FileToTest As...

Not a very good question. We might not be aware of all these names, no matter how old we are.

HEllo Jeff, Thats right but due to some reasons, I need to specify what task failed and get emails.

So I did the changes and things worked fine so far. But...

I am sure by this time it must be resolved but I have the same error and I figured out that in that particular task it asks for connection manager,...

okay thanks for the reply but when I ran the same script 5 times after 5 minutes interval, it overwrite the files every time.

Here is what it says,

WinZip(R) Command Line...

nothing has been denied on that user. I will generate a test code for you.

yes the user tries to alter from database A from ssms. since it has read,write and ddladmin rights, once he alters something and hits the execute button, he gets this...

they are on same server.

I did that but no luck.

I have a business need that when user enters data from application, some sensitive fields should get encrypted. Like values for password column should be encrypted. What I have done...

Thanks actually I had a confusion.

I have 2 tables. both have zipcode columns.

In table a--> zipcode values are = 034563456 (9 digit values for all rows)

In table b--> zipcode values...

Thanks for the reply.

2 months and 1 day. and in terms of year 1 year 2 months and 3 days.

I want all days of the month not just work days.

Hmm Thanks. I feel the same case as mentioned in this link. I am not able to see who is holding this lock and when i try to select the...