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

any current SQL Server should be 64 bit, specially if it has SSIS catalog on it - so install that one, and ensure that when you execute the package you...

thats the latest version of the driver  - you can download it from here https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15

make sure the powershell version is setting the "Binary" mode for transfer - if not and if the default is not binary it will mess it up.

double apologies - way to many here that just expect us to supply them with the links - and I misread your title and didn't confirm the contents.

Unless Paul sees...

looks like you need to learn to google. first hit when searching for it https://www.sqlskills.com/help/waits/sleep_bpool_flush/