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

abelwingnut (3/10/2016)

---

Hi,

Thanks for the advice and the welcome.

I was confusing in my post. That DECLARE/INSERT statement I posted constitutes a portion of the whole query. Following that snippet of code...

Hello and welcome to the forum.

Presumably you are doing this all in a dataflow task?

I see no reason whatsoever for the table variable. I suggest that you change the data...

Hi Andy

Thanks for the article – I think I missed it the first time round.

I wonder whether you have any intention of talking about how to set up scripted deployments...

avadeshuwaran (3/9/2016)

---

Hello,

My name is Avadesh, and I'm new to this forum. Nice to be here!

I have this SQL agent job that runs on a daily basis that calls & execute...

scohn 53313 (3/10/2016)

---

Thanks, it worked.

I have a small confession, I’m not a programmer, I’m a DBA. I’ve lived happy 48 years without knowing about the existence of GAC and...

danghita74 (3/9/2016)

---

Hi guys

I'm using an ODBC driver to access a proprietary file type database (having multiple files). So I have multiple managed ODBC connections defined, each using a DSN to...

ravi@sql (3/10/2016)

---

HI Champs,

I have huge table of 70 million records and 300 columns, and it is partitioned based on Monthkey column.And it is having clustered index as well .

Am...

TheSQLGuru (3/9/2016)

---

I'm going to STRONGLY disagree with any notion anyone might have that putting this lookup stuff into a table (of any flavor) and joining to it in in a...

ganapathy.arvindan (3/9/2016)

---

Thanks !!! Same Case statement(same code) used in 4 select statements in single SP so i thought instead of writing 4 times,whether there is anyway i can write this...