Hi Steve,

            No, the DTS is on the server machine (i.e., machine7). I have registered the server in my client (by right clicking SQL Server Group and doing New Sql Server...

Hello Everyone,

                 I have adapted the following method to put the values directly into the query instead of supplying that as a seperate parameter list. Anyways thanx everyone for helping me solve the problem.

Hai Peldin,

             I think you didn't get my question. OK i will take your example and make the question clear. In your example, you have used a variable named cname...

Oh OK,

              Any other work around to handle this situation easily can really be a great help for me

Ohhhh. OK thank you

Yeah Phill,

      I visited sqldev and found in their log that they have addressed this limitation That was awesome and a great relief...

Yeah Phill,

      I visited sqldev and found in their log that they have addressed this limitation That was awesome and a great relief...

Yes Phill,

          I looked into that sp_Makewebtask and that was awesome information for me to send the newsletter in a more confortable way but buddy...

Hai Steve,

              Thats a good point steve but I have been asked to send newsletters which cannot be an attachement

Hai Martin,

               Thanx for the site info, but I didn't find anything related to my problem (overcoming that 8000 characters limitations). Please...