I don't think that this is a SQL Server or SSIS issue.

The part of the error message which I would focus on is this: Unable to complete login process due...

Missed that, thanks.

OK. Try this

(SalesLT.Product.ListPrice - SalesLT.Product.StandardCost) AS Profit

Try changing to scale 19, precision 0.

Also, is the destination column really a 510 character string?

• This reply was modified 2 years, 1 months ago by Phil Parkin.

OK, here is my second question, once again, this time in black and white.

What should the column should be called and what calculation is required?

The existing syntax is nonsensical.

• This reply was modified 2 years, 1 months ago by Phil Parkin.

Precision 19, scale 18 works for numbers like

1.123456789012345678

ie, 1 number before the decimal and 18 after. Are your numbers in this format?

(CONCAT('£'CAST ((100.00,'C', 'en-gb'))AS CurrencyFormat)'SalesLT.Product.ListPrice - SalesLT.Product.StandardCost AS Profit')

Is this supposed to be one column or two? What are you trying to do here? It's not clear.

Bravo, that's much better.

HI Hi, I have a specific requirement for sending SQL server DB mail. In my scenario, the SQL Server query output should be sent as a PDF or Excel...

Please have a read of the following and post back with any questions:

https://www.sqlservercentral.com/steps/ssis-catalog-environments-step-20-of-the-stairway-to-integration-services

If you have deployed the package to SSISDB, create an environment containing a 'sensitive' variable to store the password.

Then configure your project in SSISDB to reference the environment and map...

I don't know the solution to your problem, but I am interested to know why you would install the rather expensive Enterprise edition on your own PC rather than the...

Here is a partial solution which shows you how to separate out the data for each of the entities.

DECLARE @x NVARCHAR(MAX)
    = N'{
 ...

There seem to be four separate entities in that file (Company, Demographics, Claims, Procedures).

Is your aim to import the file into four separate tables? If not, what is your aim?

SQL Agent runs on the server on which it is hosted, no...