jasona.work (7/28/2016)

---

We're in the process of upgrading / migrating to SQL2014 from SQL2012 and SQL2008R2. The "normal" databases are no problem (backup on old server, copy, restore on new,...

register-1103039 (7/26/2016)

---

Thanks for the replies...

Yes, is very straightforward in TSQL but when I put it in the expression of a derived column I keep on getting errors.

I just can't seem...

I've run out of ideas, sorry.

dndaughtery (7/26/2016)

---

Running the powershell script manually did uncover some issues with the powerschell script. I had gotten a copy of this from another developer who had used directories on his...

RonMexico (7/26/2016)

---

Not too long ago we migrated some 2008 databases to 2014, but the compatibility level remained set at 2008 (100). I recently changed those to 2014 (120) hoping...

ChrisM@Work (7/26/2016)

---

BrainDonor (7/26/2016)

---

Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for...

jellybean (7/26/2016)

---

Hi,

I'm using SQL Sever 2014. I'm wondering is it possible to get the ERROR_MESSAGE() statement to display the full error message. I know it only...

Try clicking on the 'Debugging' node. You'll find a property there called 'Run64BitRuntime'. Set that to false & then your debug sessions should be in 32-bit mode.

You're right: you cannot delete your posts. Editing them, however, is trivial...

You've been here long enough to know not to cross-post, so please don't. Answers here, please.

OK, that's (clearly) a SharePoint-related error.

I have not used the SharePoint destination, so I cannot offer much help.

Did you have to set up any SharePoint-related permissions in order to get...

--Comment removed after re-reading the post more closely 🙂

What do you mean by this?

...WHERE DateCol >= '20160725' and DateCol <...

uzn2010 (7/25/2016)

---

My SSIS package fails using Sql Server Agent Job. When i execute the package manually from the Sql server MSDB package store, it runs fine but when i try...