Pages: Prev 1 2 3 ...16 17 18 19 20 21 22 ...27 28 29 Next

SSIS Send Mail Task Useless Error messages

January 7th, 2009 § 3 comments § permalink

I have spent ages trying to figure out why I am getting this adequately useless error message:

Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Failure sending mail.”.
Task failed: Send Mail Task

Msdn provides a list of Integration services error and warning message definitions here, but check out the definition for this one:

DTS_E_ERROROCCURREDWITHFOLLOWINGMESSAGE An error occurred with the following error message: “%1″.

Wow.. an error occured with the following message, failure sending mail, so amazingly descriptive.

Anyway you know you are doing something severely wrong when you do a google search on SMTP Error: 0xC002F304 and only get back about 2 releveant results, and sure enough I was doing something majorly wrong.  Eventually I got so frustrated with the Send Mail task and its complete lack of error debugging information I decided to use the script task to see if that would give me any more.

So I added a new script task and ew put some VB code in and that gave me a different error that was no more descriptive than the last. Anyway that motivated me to open Visual Studio and try the same in goold old C# and sure enough…

sendmaill

My SMTP server was unable to relay to the recipient I had chosen (my personal email). Switched it to my work email and BOOYA all go.

Using the Send Mail Task in SSIS with Microsoft Exchange server as your SMTP

January 6th, 2009 § 1 comment § permalink

I have already done a similar post on this but the basics are:

  • turn on delay validation so you don’t have to enter an email address in the *to* field -> you can use expressions to read it from a table or recordset etc
  • configure your exchange server like so
  • Launch your Exchange System Manager
  • Navigate to your server -> Administrative Groups -> Admin Group -> Server Name -> Protocols -> SMTP
  • Right click on the “Default SMTP Virtual Server”
  • Click the access tab
  • Press the Relay button and add the IP of the machine that wishes to use this as their SMTP server.
  • Fun times.

white chocolate caramel oat cake

January 5th, 2009 § 2 comments § permalink

img_6492_1img_6482_1

1 1/2 cups wholemeal flour
3/4 cup white flour
2 tsp baking powder
1/2 tsp baking soda
3/4 cup desiccated coconut
3/4 cup rolled oats
1 1/2 cup brown sugar

250g butter
2 eggs
vanilla

caramel
400ml sweetened condensed milk
2 tablespoons golden syrup
150g butter

make caramel, mix all dry ingredients together in a bowl, in a smaller bowl mix melted butter eggs and vanilla, stir into dry ingredients.

press 3/4 of the mix into lined springform tin and pour caramel on top. crumble remaining mix on top. bake at 180 for 40-45 minutes or until golden.

melt white chocolate and drizzle on top.

Jam Doughnut Cupcakes

January 5th, 2009 § 1 comment § permalink

img_6500_1

I have a secret love for jam doughnuts. And on a trip to Melbourne I discovered hot fresh jam doughnuts, om nom nom so good.

These are no where near the same thing, but they do bear quite a large resemblance to the jam doughnut even though they are not fried. Best as hot as you can stand out of the oven but they do heat up well in the microwave too.

img_6515_1

Recipe after the jump… » Read the rest of this entry «

lingerie party cupcakes

December 18th, 2008 § 4 comments § permalink

panties

cupcake

matching set

*

bad choice of icing color

*

bad choice of icing color

Pages: Prev 1 2 3 ...16 17 18 19 20 21 22 ...27 28 29 Next

« Older Entries

Newer Entries »