So ... a single row in the Jobs table can have multiple related rows in the Drops table, is that correct?

If so, you could make use of the FOR XML...

clucasi (12/7/2016)

---

i am trying to convert xlsx to xls using DTS script task,but because the server hasn't got excel installed its throwing an error..Would it be ok to load MS...

Brandon Groom (12/5/2016)

---

I had this error also and it turned out to be a source code promotion merge issue with the project file. After the merge, the parameter ID in...

swarun999 (12/5/2016)

---

create procedure spgetuserdetails

(

@UserId nvarchar(255),

@Password nvarchar(255)

)

as

begin

declare @count int

select @count = count(*) from UsersTable where UserId = @UserId and [Password] = @Password

if(@count = 0)

begin

Print...

One thing you could also try is putting the results of the entire source query into a temp table, then indexing the temp table, then merging from only the temp...

TheBI (12/5/2016)

---

Hello,

I want to optimise the following query that is running so slowly.

Please help or gimme an advice.

MERGE dbo.LocalizedCategories AS T

USING (SELECT L.LanguageID,SC.CategoryID,BC.Value

FROM (SELECT...

It's difficult to diagnose without looking into what the package is doing. Is there an error handler configured on the component which is failing inside the FEL?

You wrote an error to job history? What problem do you think this is?

kpmandani (12/4/2016)

---

Not only just to determine the number of rows in the text file but based on the count, it should determine (and send) that same text file as an...

Eirikur Eiriksson (12/5/2016)

---

BOR15K (12/5/2016)

---

I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or...

Well done. I compared execution plans and my version seems to have the edge. Especially if you add an index on (requestid, eventdate, eventname). Might be worth testing both on...

I have an inelegant solution to this inelegant problem 🙂 There will be better ways, but this seems to work, at least for the test data provided:

SELECT

...

If a RequestId has been 'Closed', shouldn't the next RequestId have a different value? If they're all 46444, what's the point of this number?

Please post your data in a consumable...

OK. So you want SSIS to 'interrogate' a particular file, which has already been produced by another process, get the row count and then act according to result?

If so, your...

You have more than one problem going on here. One is regarding access to an Excel spreadsheet...