use a powershell script instead - you can get all db names, and then do backup https://learn.microsoft.com/en-us/powershell/module/sqlserver/backup-asdatabase?view=sqlserver-ps

one other possible option is to have a job that updates the xmla of...

• This reply was modified 2 months ago by frederico_fonseca.
• This reply was modified 2 months ago by frederico_fonseca.

hum... using that with SSIS would be a big no no for me - why use a cloud thing for local processing (SSIS is local to server) - if you...

have a look at this thread - I've posted good info about using the free winscp to do what you need.. from within ssis.

https://www.sqlservercentral.com/forums/topic/ssis-sftp-using-winscp

error is clear - client does not support connection encryption.

change the connection strings to ensure that encryption is optional and trust server certificate. or follow required steps to fully enable...

does not matter what tool you use - you talk about a "reporting application" - as it does not take a text field, then datetime is what you use -...

SSMS will show up whatever format is defined by you/ your locale.

your reporting software is what needs to do the formatting to UK format, not your sql, neither what you...

2 beers.. you triple posted

original code has been subject to an incorrect replace somehow.

but it should have been easy for you to identify where an alias is missing and which columns refer to it...

you mentioned ETL - depending on the tool (SSIS for example would require this) you may need to open each of those packages and regenerate column definitions.

what/how and IF depends...

best practice is to grant required permissions only, and not to add to local admin.

If the install of the instance is done with the correct type of user, all those...

but main question is why you need a cursor/while loop?

the reason why the code was removed (post deleted really) is because since sometime ago any post that contains 2 URL's gets that treatment. there is no error, just normal...

they are within the catalog for sure as I use it as well.

but I also change the default cleanup settings and server lvl logging

second link - EA from sparks - paid but good.. and does a lot more than that. it is a architect tool.

https://sparxsystems.com/

hum. I had posted 2 links and post was removed.. darn sotware.

first link - it is free (java based) and works well enough - to use with SQL Server a...