vinodkm (4/21/2016)

---

Hi All,

Please help me to understand how to connect SSDT projects to TFS.

Actually my requirement is to keep version for SSIS packages, SSRS report and SSAS projects in TFS.

Thanks...

VastSQL (4/21/2016)

---

Hi Experts,

We have more than 100 Foreign Keys with no supporting index. Do we need to add index on all these Foreign Keys ?

Can someone help on fixing this...

Same again, but with my SELECT MAX() solution tagged on to the end.

CREATE TABLE temp (ID INT, Date DATE);

WITH E(n)

AS (SELECT...

astrid 69000 (4/20/2016)

---

Thanks so much.

I read and read and I understood. and it worked :-P:-P

Here is my code

declare @x xml

DECLARE @site_value INT;

SET @site_value = 0;

WHILE @site_value <= 1000

BEGIN

select @x =...

Here's an UPDATE version:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test

(

Id INT PRIMARY KEY

,dt DATE

...

Dhivya Elan (4/20/2016)

---

Hi Phil,

I tried using the ForEachLoop container. Here's what I did:

1) Made all my Excel Source tabs identical, by adding missing column headers (although they might not contain...

Dhivya Elan (4/20/2016)

---

Hi John

I've been trying to use the derived column transformation, unable to find a guide on how-to, that matches my requirement. I would really appreciate any helpful links....

Dhivya Elan (4/20/2016)

---

Hello All,

I have recently started using SSIS, and have been exploring various transformations trying to make the best use of them. I currently have a requirement where in,...

rafnunes (4/20/2016)

---

thanks for your answer.

But correct if I'm wrong, after reset SQL server Service and application the lock should not disappear?

It's possible to know if a table is locked,...

singhamitpal (4/19/2016)

---

I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

1.Very few developers will be able to create a consistent stored...

rafnunes (4/20/2016)

---

I have a code that execute this steps in some table:

1 - Update 5000 rows with will be to extract, is a bit column with value NULL 0...

Eirikur Eiriksson (4/20/2016)

---

Phil Parkin (4/19/2016)

---

Ed Wagner (4/19/2016)

---

Are...

pvong (4/19/2016)

---

Phil, thanks for your help.

Jacob, I marked you as the answer because I learned how to do an error output file thanks to you suggesting it. Remember, I'm...

singhamitpal (4/19/2016)

---

Thanks for the response...

I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really...

I'm sure you know this, but ispac files get deployed only to SSISDB (as far as I know).