Not sure what is the data size of the table?

As mentioned by Johan, Grant access to the network folder. If it is not in your control, ask your network admin to provide access to the sql agent service account.

You...

Use SSMS, Connect to two different instances/databases in separate query windows...

Go to Windows menu --> Click New Vertical Tab Group

First convert the PDF to excel format. Remove any unwanted lines, rows or any characters. Verify the data is correctly formatted, then save it as .csv file.  Use import/export wizard...

If it is windows, check the event viewer for more details on the error on the server.

I would  enable 'xp_cmdshell' as a first step in the job and disable as...

Looks like it is PostgreSQL script with pgAdmin tool screenshots.

I was able to create this job in my dev sql environment and ran it successfully. No issues et all.

Make sure the sql server service account has access to all...

Hi,

You cannot upgrade directly to version 2022. Upgrading a SQL Server 2000 database to SQL Server 2022 directly is not supported. However, you can follow these steps to upgrade your...

I am not sure about a windows user.

However, a database user without login cannot log into SQL Server,  but exists as a database object and can be granted or denied...

Hi,

Are you trying to run a DTSX package with encrypted column, If not can you elaborate your question?

You have to make sure the linked server options are enabled to True. This will ensure and convert the local transactions to global transactions when you call a procedure or...

@AER:

SQL Server has resource hungry processes, you add RAM it will take it... and wait for more.

Every environment varies as suggested by others there is no straight answer.

Are you experiencing...

This should not be a big deal.

If it is not huge and I hope the legacy...

I have not used 2022 SSIS.  But worked on lower versions, build the package and set it to 64bit runtime under properties in VS. After the package is deployed you...

• How many employees are you trying to process?

  If the data is huge then go for storing in permanent table, update the table with any legacy data changes.

  If it is...