unfortunately and as I said the only way to use it outside SSDT is to have it fully licensed - see https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver15

depending on what you are trying to do you...

and be careful with doing it that way. SSIS is a licensed feature of SQL Server so any PC that executes it will require a full license of SQL Server.

SSIS...

using just min/max/avg will not help much if you have stragglers - you are better off ranking then on durations and then look at the specific ones that are on...

Does not matter what possible options we give you to process from the queue - unless you tells with great detail what you are doing with each row on the...

MAX Server memory should never be left at the default - with 128 GB ram and with SSIS running on same server I would give SQL a max of 100-110...

• This reply was modified 5 years ago by frederico_fonseca.

Since SSIS is not SQL - it isn't the same - and the code is not processed as SQL code. Since the data is in the file -...

PowerBI will cache - but if using direct query it will also push the query down to SQL Server - and in this case it will shine if doing aggregations...

that's a basic OR statement -

and (invoiceamount = @amount or @amount is null)

powershell has a quirk - exit status is not the one of the last command executed - been bitten by this a few times.

whatever you do within your scripts you...

no need for further variables.

just do the conversion in sql

delete from T1 where date_cr between convert(int, ?)  and convert(int, ?)

We manage SQL Server data in a growing environment where our One of the most popular archiving techniques with data that includes date and can be scaled early...

I already gave you a alternative solution - up to you to decide which route you wish to take.

it is very likely - look at https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/system-tables-sqlserver.htm

looks like this bit "The adds table (a_<registration_id>) maintains information about each inserted or updated record (feature) in a versioned business table and...

I assume you aren't going to be running this on a server - " New-Object -ComObject Excel.Application }" - this requires Excel to be installed on the server which is...

• This reply was modified 5 years ago by frederico_fonseca.

it has more than 4 properties - but unless you specify -properties * or -properties comma_delimited_list_of_properties it won't "show" them to you.

even for on prem AD I would advise you...