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

a case statement is going to lock you into one datatype, so i would simply use money(= Decimal18,4)

and do the math in a case statement;

wouldn't something like this do the...

since you have CMS set up, I would use a powershell script to poll each CMS server, and insert data into a centralized table.

then you could generate an SSRS report...

the example here:

http://ss64.com/nt/syntax-delolder.html

is so close to your version, i'm not sure there's an issue:

the only thing i see is that the example uses slashes instead of hypens for the...

my example contained the word [ColumnList] as a placeholder for...

Phil Parkin (12/16/2016)

---

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you to...

you said find duplicates in the first post.

INTERSECT finds...

i always put my audit table in the master database, since it is guaranteed to exist, and all logins inherit some access to it.

someone already mentioned the three part insert:...