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

Here's an alternative – not as elegant, but may perform better:

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

DROP TABLE #tab1;

CREATE TABLE #tab1

(

A...

--Removed

rjjh78 (7/22/2016)

---

Hi,

I had been part of a business project where I have spent over 200 hours on software development. Involved is a money guy, the idea guy, and myself...

dndaughtery (7/22/2016)

---

I changed the executable to C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe in the process tab of the execute process task and now getting a different error:

"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-ExecutionPolicy Unrestricted -File"\\MyServer\Myfolder\FolderA\Powershell_Scripts\Get-Files.ps1"" at "", The process...

vinodajacob (7/22/2016)

---

Just wondering what everyone's take is on the Intellisense tools that are installed as add-ins to SSMS

I personally think that the Devart SQLComplete tool is the best because it...