Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for you yesterday @4:40pm(less...

thakur.bhagat24 (12/20/2016)

---

In previous example is very useful

But I have one new requirement of order by color what we get using below case.

CASE WHEN (ROW_NUMBER() OVER (ORDER BY [SpecialOfferID]))%2...

here's a C# code example, change directory to file, and

try

{

string FileName = (string)Dts.Variables["BHCS_InPatient_File"].Value;

...

what is the issue? you've been around long enough to know exact errors and a description of the...

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...