You need the password that encrypted the package to decrypt any sensitive data, without it the password to any sql connection as well as any other sensitive data is garbage....

Ok nevermind. I found the cause... didn't know that the 266 get raised every time the tran count is different before and after executing an sp. That makes...

amer-887457 (11/18/2015)

---

No errors whatsoever.

This is literally one of those 'sometimes it works, sometimes it does not'

I see the OLEDB getting one row as expected, firing just fine, but update does...

jbalbo (10/21/2015)

---

Hi

I am using the following "MySortedRows" routine

...

select count(icd10)as counticd10 ,icd10

,ROW_NUMBER() over (order by count(icd10) desc) as Row

,case when ROW_NUMBER() over (order by count(icd10) desc) > 5 then...

There's isn't enough information on what you want to accomplish here. 30 of what query? What is the end result you're looking to get?

You can try setting the columns up as CHAR/NCHAR(x) instead of varchar or nvarchar... that should fix your width...

I would check the ports to make sure it's not blocked. If I remember correctly in the configuration manager you can set the active ports for TCP/IP to be...

Thanks Jeff... that helps me remember it if I understand why it's doing what it does.. 🙂

Add this to the end?

,@x.value(

'(sql_variant1)[1]','FLOAT')

,@x.value(

'(sql_variant2)[1]','FLOAT')

If I remember correctly with 2008 R2 you don't need separate msdtc... I'm 99% sure that you only need 1...

Luis Cazares (9/4/2015)

---

As you're reading all the rows from YTD, I guess a single scan should perform better.

Be sure not to get lost on what this is doing. Since you're...

Something like this maybe...

Also check out Jeff Modden's article on cross tab/pivot... I think the part about aggregates is useful..

http://www.sqlservercentral.com/articles/T-SQL/63681/

declare @EmpID int = 1

declare @ChkDate date = '2015-6-15'

declare

SUBRAHMANYA HEDGE (9/4/2015)

---

Hi DBAs,

We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.

Now we need to install another...

SQLPain (9/4/2015)

---

Thank you so much,

The dilemma I am facing is that job is averaging 21 hours and it is scheduled for everyday, so the job pretty much keeps running all...

Try something like this for the first step... not sure why it was put into a loop... unless I'm missing something...

declare @LoanID as table (LoanID varchar(10))

insert into @LoanID(LoanID)

select LoanID...