Syntax error, permission violation, or other nonspecific error in SSIS 2012 - SP1

Syntax error, permission violation, or other nonspecific error in SSIS 2012 - SP1 - please help

Hi,

I have a package. I execute this in DEV server and its executing successfully.
The same package when i execute in QA server , i got the error as
Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error".

Can you please help me to resolve this?

DEV server version is - Microsoft SQL Server 2012 (SP1) - 11.0.3393.0 (X64)
QA server version is -Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64)

In the package, there is a DataFlow task and inside that, in the Source -> OLEDB connection manager, i use a sql query with a parameter. Is that a problem in QA server version? Please help!!

August 26th, 2015 9:06pm

Refer thread and see answer of James Alexander

https://social.msdn.microsoft.com/Forums/en-US/91b0c6e8-e18c-4113-837b-aaff0ec3ad6e/problem-with-ole-db-command-transformation?forum=sqlintegrationservices

Free Windows Admin Tool Kit Click here and download it now

August 26th, 2015 9:15pm

Thanks - So, it will get resolved if i use SP2 ?

August 27th, 2015 12:07am

This topic is archived. No further replies will be accepted.