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 3 years, 10 months 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...

/FILE is the way to go if what you posted on originally is indeed what is being requested and done.

as you can see on the top examples here https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-ver15#bit

the command...

Command line is:

dtexec.exe /DTS "\"G:\SSIS\Folder\MyPackage\"" /SERVER MyInstance /CONFIGFILE "\"E:\Folder\Configfiles\MyPackage.dtsConfig\"" /CHECKPOINTING OFF /REPORTING E

change to:

dtexec.exe /FILE "\"G:\SSIS\Folder\MyPackage.dtsx\"" /CONFIGFILE "\"E:\Folder\Configfiles\MyPackage.dtsConfig\"" /CHECKPOINTING OFF /REPORTING E

No admin required - that is just bad clarification - just required priv required on DCOM which can be given to a non admin user/group.

see https://dba.stackexchange.com/questions/77320/how-do-i-grant-the-privilege-of-connecting-to-ssis for how to fix...

or a Stored proc with a straight sql to retrieve the data from a linked server into SQL Server

caveats - which also apply to SSIS - dataypes conversion between oracle...

regarding reorganize - there is an exception to this  - if you have columnstore indexes that are frequently subject to deletions or that are subject on inserts in small batches...

• This reply was modified 3 years, 11 months ago by frederico_fonseca.