Why is there so may duplicates in this thread?

We would need more information.

- Please give us some example data in the flat file, i.e. one of the rows being inserted.

- What is the data type of the...

Not sure what you mean here, Iv only so far tested the XML...

OK, So iv first tried using the XML method.

I have created the XML which contains the SMTP properties.

I cant seem to work out how I would now use send mailto...

Thanks Derek Dongray and Aasim, I will try both on my test system and see which one works well for me.

Question:

If each send mail as differant critira, i.e. Subject Line,...

Well not sure if this helps, I have inserted several "Flat Files" into one "OLE DB". Each file will load into a differant table within the DB

- You Need...

Well nto sure if this helps, I have inserted several "Flat Files" into one "OLE DB". Each file will load into a differant table within the DB

- You Need...

Firstly, Lynn Pettis, Steve Jones sorry this has wasted so much of your time.

Secondly, I would like to thank Lynn Pettis & Steve Jones for your support.

As you can see,...

ok, thanks

lol your an even bigger **** if you think your getting an apology.

And for your information, I was hoping you would read my reply.

Funny man!

Fantastic!

Can you give me some pointers in how to set this up?

Thanks very helpful!!

But a few questions.

Add the variables that are to be passed from the parent package.

Parent Package being the main SSIS package, Child being the "SendMail" task only?

Do...

Thanks, reason I ask is that, I have a number of SSIS packages which use "SendMail" task.

I wanted on "Master" package which olds all the indervidual send mails task. ...

Anyone?