Alternatively you can call a report from Powershell and feed it parameters then send the resulting file by email using Powershell commands. This gives you the ability to change the...

Hi, We had that exact problem. After upgrading the package in VS2012 and re-deploying it, the VB bits of the package ran fine on a SQL 2014 server. I did...

Kev,

Thanks - the server was 2005 but the compatibility level was still 2000. It worked find after that change.

Mark

I get this error when creating the SP: Msg 102, Level 15, State 1, Procedure dba_WhatSQLIsExecuting, Line 42 Incorrect syntax near '.'.

Line 42 is the 'CROSS APPLY' line.

Can anyone help?