g.britton (8/27/2015)

---

Found the problem: As simple as a typo in the servername!

Fixed the typo, all works as designed. I can configure the SmtpServer, the ConnectionString or both.

Pity that...

So if you fill in actual values for those variables (and no configuration), the package works flawlessly, but once you turn on configurations the package fails?

Okay, so we know it's not the tasks themselves that fail, but rather...

Something from before my time 🙂

If you remove the configurations and just hardcode everything, does it work then?

Great question, thanks.

Learned something new.

I've written a follow-up article on the Temporal Table tip (which is already listed in this article):

SQL Server 2016 T-SQL Syntax to Query Temporal Tables[/url]

Maybe it can be added to...

Nice one, thanks.

In that opinion, Power Pivot is also part of Excel 2013.

Both are however listed...

Easy one. All the names need spaces though 😀

I'm no DBA, so I don't have a "daily set of instructions I need to run", but I use those quite a lot:

sp_spaceused 'TableName'

sp_who2

IF OBJECT_ID('tempdb..#Results') IS NOT NULL

...

ChrisM@Work (8/21/2015)

---

Sean Lange (8/20/2015)

---

Luis Cazares (8/20/2015)

---

Lynn Pettis (8/19/2015)

---

Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find...

Link?

Sean Lange (8/19/2015)

---

Ha Ha!!! I was just beating my head against the wall when inserting varchar data into an nvarchar column and struggling with why it was not working. That...

Grant Fritchey (8/19/2015)

---

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is...