Thank you, sir.

I believe you're correct - it's a Kerberos double-hop issue.

I checked the sql server logs on instance B and found this line. When I execute the SSIS...

A report that shows timespan of the analysis and then total for the TagID then Unique and Nonunique(differnt value)

There where 800 captures and 750 all had same value and,...

What are your desired results, based on this sample data?

One final idea. Could it be a Kerberos double-hop issue? To test this, try using SQL Server auth for your connection, rather than Windows.

The reason I mentioned it was just to make sure that you'd filled in all the parameter and connection override info on the GUI screen before submitting?

Are you using SSISDB environment variables to override connection configuration?

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 1 year, 7 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 1 year, 7 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...