one initial question - your query has lots of functions - as it is anonymizes we can't see what they are, but can you at least clarify what they are...

as a zip file it works as seen below - you may be able just to rename the .sqlplan to be .sqlplan.zip and upload it

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

estimate will most likely help - not as good as the real thing though.

as for the @variable - never saw that error on Plan Explorer - if you save the...

homework - final big work I would say.

when you are running the query you still not using Plan Explorer - that is all SQL Server on its own.

only once the query runs and SSMS produces the explain...

SQL Sentry will only "reveal" itself on SSMS when you have done a explain plan and have the window with it visible.

at that point right-click on it and  you have...

see this example - with it you should be able to set  your ssis to work with the rowversion value

/*
if object_id('test') is not null
drop table test
create table...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

with the caveat that if using the latest version of SSMS you loose the Debug capability

you can use SQL Sentry (https://www.sentryone.com/plan-explorer to post a anonymized plan - that will keep your restrictions in place as all names / variable contents are replaced with identical names....

with newer technology it is possible on the SAN side - look for example at Dell XtremeIO - its snapshot technology means you can just click the button and you...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

without having both procs there's nothing I can do - it may be a slight error on your SprocA that causes the table not to be populated

you need to install the EXACT SSDT version I mention above - download it and install onto a new VS 2017 instance - it will do a Shell install which...

depending on your VS version it may not show up at all - VS2019 for example will use a different driver (replacement from Microsoft of the Attunity one )

To use...

I would note that if the purpose of this query is just to output to a file for consumption by other system then using a different method would probably be...

you can create a unique filtered index on that column - it will prevent inserting more than 1 row with it set to true.