Thanks Lynn Pettis for looking into the issue.

First question, can a given Customer (Unique CustomerCode have more...

Hi Dinakar,

               Thanx for looking into my issue. Yeah, I have tested my original query and the indexed one before plugging into the procedure. And the average time consumption of...

Hai Brian,

            I wish on setting the port #25 manually, the mailing should work. If there is anything related to security settings, please let me know so that i do that...

Hai

        Thanx for your focus on this topic and trying to solve my problem.

        OK machine3 and machine7 both has VS.NET 2003...

Hai rudy,

             Can u please reframe your question? I 'm not able to understand what you are trying to say. As far as sending mail is concerned I 'm able...

Yes, I have local access to the server.

Now that I have created a package from my system machine3 on to the server machine machine7. In this case I 'm...

Hai Darrell,

               Thanx for your helpful tip man...But I will be able to adapt this only when the instance of the RecordSet oRs really gets hold of an recordset object and...

Hai Don,

I have created an instance of the remove server in my SQL Server group in EM. And I 'm executing the package from my machine by selecting it, then...

I 'm binding my GV from a rowset and therefore it is displaying me Dispatch

Hai Don,

            Thanx for you reply. I 'm using the CreateObject method on the COM object ADODB.RecordSet and no activex for this in any manner

            Then I discovered that ActiveX doesn't...

OK,

       I removed Set and now it gave me the following error:

Object variable not set

First...Thanks everyone trying to help me solve the problem

I 'm using sp_OACreate method to send mails to the customers and it is working...

Yes John,

             The owner is sa, but still the problem remains

No Carl,

          There is no DSN or anything that is in my machine that is different from machine7 that I have used in the Package. I have created this package...

OK...

       Now the package seems to execute but not getting the same result that I get by executing it directly .

       The stored procedure that calls...