not a rowbar as such - but it gives a nested loop operator.

but as your code is not the real one why don't you post what you really have -...

SSIS is not the best neither the most professional way to do it.

Most times SSIS should not be used at all, and it can be the source of the biggest...

do not use linked servers to push data to a SQL Server - it does so on a row by row basis.

always pull - or use a process outside SQL...

see this for edge https://stackoverflow.com/questions/57034199/integrated-windows-authentication-in-microsoft-edge

and this for chrome https://knowledge.kofax.com/Smart_Process_Applications_-_TotalAgility/Configuration/Configure_Chrome_To_Allow_Windows_Authentication_Without_Prompting

CONVERT(varchar, DecryptByKey([Password_Encrypted])) AS 'DecryptedPwd'

first - NEVER use any data type without specifying its type

decryptbykey returns a varbinary(8000) - so convert it to a varchar(8000) or varchar(max)

second - if the bytes...

option 3 - but with addition of fields

• time created -- used to determine how long it has been identified as an issue
• validated by
• validated date
• validation status (ok/not...

hum. should not be that slow but possible if the records are big - what's the file size?

is it possible to share the file (even if on private) for me...

as most of the features that were Enterprise only on 2008 are now standard featured I would just try and restore the db onto a 2017 standard edition - if...

try this function https://github.com/RamblingCookieMonster/PowerShell/blob/master/ConvertTo-FlatObject.ps1

most likely you may be able to do

[xml]$file =get-content $tempfile

$datatable = convertto-datatable -inputobject (ConvertTo-FlatObject -InputObject $file)

it needs to be all in same line - based on your output you have the sqlcmd in one line then the server name on a new line.

no update would not be like that - but as said you do not need to do the update.

update ca1
set ClientNotes = replace....
from ClientDetails as ca1

but that...

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

Common is likely because it can be used anywhere on the same query multiple times unlike a derived table/subquery.

why do you need to remove them to extract them?

surely you are extracting into a properly defined CSV file and if so that does not matter - unless  you are...

no benefit - Express will use a maximum of 1 GB for database engine

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)?redirectedfrom=MSDN

question is incorrect - but I guessed what you wanted.