Hi, I'm creating a dtsx package and I'm obtainning a couple of errors. The first one is this:
Código de error SSIS DTS_E_OLEDBERROR. Error de OLE DB. Código de error: 0x80040E37.
I've looked for info about it and I've found that I should set the Quoted Identifiers to true. The problem I've is that I haven't found the option on the properties. Then I've tried ot insert it before of my query (the query works fine):
SET QUOTED_IDENTIFIER ON
SELECT CAST(tvp.ATR_PROVEIDOR_TX AS NVARCHAR) AS PROVEIDOR
,CAST(tvp.ATR_GRUP_ASSIGNACIO_TX AS NVARCHAR) AS GRUP_ASSIGNACIO
,CAST(tvp.ATR_PROPIETARI_TX AS NVARCHAR) AS [...]
kilofafeure
Participant
1507 Points
753 Posts
Error 0x80040E37 in dtsx package
Jan 21, 2013 07:58 AM|LINK
Hi, I'm creating a dtsx package and I'm obtainning a couple of errors. The first one is this:
I've looked for info about it and I've found that I should set the Quoted Identifiers to true. The problem I've is that I haven't found the option on the properties. Then I've tried ot insert it before of my query (the query works fine):
but I'm obtainning the error again.
I've also found this in this link: http://www.bidn.com/forums/microsoft-business-intelligence/integration-services/1014/dynamic-excel-file that I should do this: "You need to set the DelayValidation property to True on the Data Flow Task". But I'm obtainning the same errors.
Could someone explain me how to solve this or where could I find the property QUOTED_IDENTIFIER? Thanks.
kilofafeure
Participant
1507 Points
753 Posts
Re: Error 0x80040E37 in dtsx package
Jan 21, 2013 10:09 AM|LINK