kindly keep this to a single thread - you have 3 threads all around the same issue for no real reason.

also a search on google immediately gives a results that...

Here's the next thing that could be a possibility... Run this code in the database where the table is at.

 SELECT is_read_committed_snapshot_on
   FROM sys.databases...

can you run the following - sp_spaceuses sometimes reports wrong sizes

select t.NAME as tablename
     , s.Name as schemaname
     ,...

no clustered index on that table? or columnstore?

if not then it is a a heap so see what the resulting size is after you issue "alter table [dbo].[SIData_222222_88_20211103_1436] rebuild"

if it does...

can be lots of things

• has file been processed - requires another table with list of files already processed (filename, time last written and similar)
• do filenames match expected pattern

...

why?? it is such a "wonderful" tool.. and so so easy to deploy and work with...

you don't need enterprise to have SSIS - but the other editions lack some functionality - fuzzy lookup is only available on the enterprise version so if this is the...

Hi Frederico,

BTW. I tested 18.5...

and when you try debugging what error do you get? unless for some reason your 18.10 does not have the debug menu at all.

standard way of debugging.

window with exec... and hit F11

• This reply was modified 4 years ago by frederico_fonseca.

Schema compare - same way that ADS requires an add-on to do it, SSMS also has a free add-on (from devart) that can be installed to do it - so...

BTW. you forgot a very important feature for developers: debugging stored procedures. SSMS 17 still can it, SSMS 18 not - ADS? That feature is more important than the...

something minor for sure - even a single quote vs double quote could cause the package not to be opened.

glad you sorted it out

we have both (on top of those that are on SSIS catalog)

in some servers the packages are stored on a SAN drive attached to the server (with a drive letter...

MS documentation can be tricky - as Control is a superset of permissions that contain ALTER it means that CONTROL should never have been worded as being a minimum permission...