lkennedy76 (3/15/2016)

---

okay guys, I am stuck. I have two columns that I need to add and make one total for a report. there are null values so I have to...

WHERE [column] not in ('x','y','z')

dan-572483 (3/14/2016)

---

Using SSQL Server Data Tools for SQL 2012, one of my Data Flows got "moved" to the bottom of a huge workspace, meaning that when I open it for...

sqlnewbie17 (3/15/2016)

---

How do I build an SSIS package which will have a dataflow task within a foreachloop container.

The dataflow task has source and destination ole db's.

At the beginning outside of...

yb751 (3/14/2016)

---

I started working with the hierarchyID data type. So far it's been pretty great working with the built-in functions rather than having to use recursive CTE's.

Consider the...

Jack Corbett (3/14/2016)

---

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store...

Jack Corbett (3/14/2016)

---

I like Lowell's solution and I think it will perform better than an AFTER update trigger because the AFTER trigger will require 2 updates to take...

SQL!$@w$0ME (3/14/2016)

---

Thanks Phil. Can I accomplish this with just one update trigger?

Can you give me a logic for the update trigger. The script below is not working as intended.

--Column...

SQL!$@w$0ME (3/14/2016)

---

using UPDATED and DELETED temp tables, how can I override the new value and keep the old value for a column using UPDATE trigger. My requirement is not to...

Brandie Tarvin (3/14/2016)

---

Steven.Grzybowski (3/14/2016)

---

Brandie Tarvin (3/14/2016)

---

Eirikur Eiriksson (3/12/2016)

---

Brandie Tarvin (3/11/2016)

---

What a wonderful

Still not sure if I like Data Tools or not. It seems very sensitive to every little click...

Brandie Tarvin (3/14/2016)

---

This one is confusing me a bit. We have a 2008 SSIS package that has been running fine until yesterday. Suddenly it won't send a file via SFTP...

I'm no expert, but that does sound like it might be Kerberos related.

Perhaps you could do the INSERT followed by

DECLARE @RwCount INT = @@ROWCOUNT

IF @RwCount = 0

BEGIN

--Insert here

END

danghita74 (3/10/2016)

---

Thank you Phil

I thought would be something like this.. unfortunately I do not have enough experience with scripting inside SSIS. And I'm a VB guy, not C# (nobody's perfect,...

2. I agree with Phil that dbo.SnapShot is probably indeed a table, but it could also be an indexed view. Not likely, but if you fail to find dbo.SnapShot in...