OK, I looked closer at the error and it sounds like Integration Services was not installed on the server. This is part of the SQL Server installation process and not...

That does not tell you the version of SQL Server. Please run this query on the server and post back the results:

SELECT
    Version =...

What version of SQL Server 2019 is installed? (Enterprise/Standard/Express etc)

Can you confirm that you have other SQL Agent jobs configured which execute SSIS packages?

The VS extension which allows you to...

DT_DECIMAL does not have a precision. Use DT_NUMERIC in your formula instead.

Although this does not address your question, I'd be tempted to try out this alternative syntax:

WHERE NOT EXISTS
(
    SELECT x.status
    ...

WHERE sent_rowid is null or vendor = @vendor_param

?

Frederico's message is spot on, as usual!

In my opinion, Excel should almost never be used to view *sv files, because as part of its parsing, it tends to display values...

If your databases are fully source-controlled, it should be possible to simply deploy them from the relevant branch. The act of deploying will take care of most of the DDL...

Dynamic SQL is one way of creating a variable SELECT statement that can be executed.

• This reply was modified 1 month, 1 week ago by  Phil Parkin.

Thanks Phil. I will check this.

One more query related to this. In the screenshot you can see that "save my password" is checked for the user "SA". How can...

Different people will do things in different ways, as it depends on how you want to work together, how many developers there are and how many projects there are.

I work...

If you do not have a server called CCSQL, I think it may be an alias to a server.

Read more about aliases here:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver16

If you don't need or want to...

Can you provide a screen shot, as I'm not sure exactly what you mean?

Not sure what that is, but try pressing 'Parse' (CTRL/F5) on it and you'll see that it doesn't.

The code fragment I posted would not create that error. Can you post the entire text of the query which is giving that error?