Thank you for the replies. I have tried OLE DB Source, but it failed on preview. I do see the result if I run a simple SELECT  myClumn FROM...

You've been here long enough to know this...

If you want a coded solution, please provide sample DDL and sample data in the form of INSERT statements.

Does anyone know of a way to only deploy a single package between 2 SSIS Catalogs -- NOT using Visual Studio's package deployment feature.  I want the version of...

Not sure how you want the output formatted, but does this help?

DROP TABLE IF EXISTS #Stuff;

CREATE TABLE #Stuff
(
    StuffId INT NOT NULL IDENTITY(1, 1)...

You can use MAX to make this work:

SELECT t.ID
      ,MAX(t.LegalName)
      ,MAX(t.City)
      ,MAX(t.Zip)
FROM...

Assuming Cost = 500, FeeMargin = 10% and NettMargin = 5%

Sell - Cost - (Sell * FeeMargin) / Cost = NettMargin

Sell -500 - (Sell * 0.10) / 500 =...

Phil

I am struggling to explain this, hence  a valid result in the table.

I need to calculate the sell price by changing the nettmargin

The cost and FeeMargin will persist. The...

Your TEST table appears to include all of the items which you are trying to calculate, making this a little difficult to fathom.

What are the inputs to the problem and...

Too busy trying to cool down their server CPUs after all those wildcard searches, no doubt.

Here's the same example using a...

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

Here is another possibility, which separately adds the hours and minutes to the starting date:

DECLARE @d DATETIME = '20201120';
DECLARE @i SMALLINT = 725;

SELECT @d
,   ...

Is the package deployed to SSISDB? Did you use the project or package deployment model? Do you use project parameters or connections?

Thanks, Sue

I tracked down the only version of RegSvr.XML I could find on my machine and it does not appear to hold the same list of registered servers which I...

And where are you expecting the messagebox to be displayed?

Change your simple script such that it does not require any sort of UI interaction and you should find that it...

You would probably do something like this:

DECLARE @LatestExpiredDate DATETIME = DATEADD(d,-1,GETDATE())

SELECT * FROM Book_Reservation br
WHERE @LatestExpiredDate >= br.reservation_To_date

This sets a temporary variable to the date/time of 'now'...

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