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 4 years, 8 months ago by frederico_fonseca.

removing HT will not reduce the licensing - the licensing is per core or vCpu if on a vm and the host not fully licensed (Entreprise + SA).

if it is...

powershell_ise is a good enough debugger - may need to be installed on pc as its not always ticked by default.

close all your visual studio instances - if that does not work restart your pc and do the install then - without opening VS again!!

for me it would mean using TDE as this is encryption at rest for all I know - I would ask whoever requested it to ensure that is what they...

• This reply was modified 4 years, 9 months ago by frederico_fonseca.
• This reply was modified 4 years, 9 months ago by frederico_fonseca.

when you build you sql string just make sure to replace any single quote with two single quotes - that will solve the issue with SQL while keeping the data...