SSIS/DTSX/ETL error: "The data in the reparse point buffer is invalid."

Question

I have an SSIS/DTSX/ETL which is giving me the following error in a "Task" in the "Control Flow":

[Execute SQL Task] Error: Executing the query "" failed with the following error: "Could not retrieve COM class factory for component with CLSID {8957A18C-F62B-4A46-83FC-E8792FFD06DC} debido al siguiente error: 80071128 The data in the reparse point buffer is invalid. (Excepción de HRESULT: 0x80071128).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The only thing that this task does is execute an SQL query on a SQL Server DB. To edit that DTSX I use "SQL Server Data Tools 2015". The DTSX was created with VS 2010 Ultimate, I don't know if that has to do with the problem...

As shown in the image, I am executing the following SQL Command:

DELETE FROM TBLEMPRESAREPRESENTACION

It would be helpful if you write the code you are executing inside the "Execute SQL Task". HAve you looked at this howtoedge.com/fix-invalid-reparse-point-buffer-error-0x80071128 ? — Nicolaesse
– Nicolaesse, Commented Mar 3, 2022 at 7:20
Hi - one of the rules for this site is that all questions must be in English. If you wish to ask a question in another language then there are other language-specific versions of Stackoverflow available — NickW
– NickW, Commented Mar 3, 2022 at 8:46
I’m voting to close this question because the question is not in English — NickW
– NickW, Commented Mar 3, 2022 at 8:47
@NickW I tried to translate the question. But, I think that it should be posted on es.stackoverflow.com — Yahfoufi
– Yahfoufi, Commented Mar 3, 2022 at 8:48

Yahfoufi · Accepted Answer · 2022-03-03 10:33:07Z

0

Make sure that the TargetServerVersion is correct and set to the current SQL Server installation:

How to change TargetServerVersion of my SSIS Project

answered Mar 3, 2022 at 10:33

Yahfoufi

2,5502 gold badges26 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS/DTSX/ETL error: "The data in the reparse point buffer is invalid."

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related