also a try catch to capture any errors raised you did not expect.

http://www.sqlservercentral.com/Forums/Topic942127-364-1.aspx

local_net_address is the server itself, don't you mean the client_net_address instead?

--EDIT--

anyway, I don't think IP address for the connector is exposed anywhere in Extended Events. you might get away with...

right, that of course was one of the places i've been looking, as well as the classic slowest running queries.

this package is extremely simple, it's pure truncate and reload,...

I saw the error message; that was what made it clear that the alias for the color...

weird; via the GUI, i am able to set the background on either the page or the body with no problem, for example.

i don't see the color until it's rendered,...

color Aliases do not have a spaces in them. LightGreen would be correct.

anupam.jha (12/20/2016)

---

Hi Gents,

I have landed into a scenario where we have around 60 to 70 SSIS packages that would be loading data into the datawarehouse.

Most of the individual SSIS packages...

you should start a new thread to get a bit better help;

however, here's a decent framework to start with.

the email portion is the easiest part, really.

the only thing you need...

here's an example of your code.

your example has no where statement. which doesn't make sense to me, you'd want to filter on a table,a nd send if there is data.

i...

i always insert into a temp table,and then check if exists:

SELECT *

INTO #temp

FROM [AdventureWorks].[Sales].[SpecialOffer]WHERE SomeFilterOrColumn =SomeValue

IF EXISTS(SELECT * FROM temp)

BEGIN

--all the email logic you had previously

--but FORXML select from...

Reconsider the tool to use for your project;

This post started out with "how to include an image in sp_send_dbmail".

certainly possible, but is the right tool for your specific question...

I tend do do commands like this in a script rather than the GUI;

my example script would look something like this:

CREATE ROLE DevelopersReadWrite;

GRANT VIEW...

DataAnalyst011 (12/16/2016)

---

Do you mind if I ask one more question? Obviously your code works and mine didn't. However, do you use the @@ROWCOUNT method because it is faster? I've pretty...

i would handle the upsert like this:

also, i think you granted INSERT to public, but you did not grant UPDATE or SELECT to public, so that is a point of...