Does table 2 contain any data currently?

If you need to control the value of EmpNo in table2, you should set it to be an INT, but not an IDENTITY.

Can you...

Try this

SELECT customer_name
      ,order_id
      ,status = (CASE
          ...

CONCAT is not a safe way to do this because different values could appear to be the same.

Do all the columns have to match?  Or just some?

For now, I'll...

Jeff's queueing idea is the way I would do it.

Doesn't feel like a 'nice' solution, but this might do it.

DROP TABLE IF EXISTS #t;

CREATE TABLE #t
(
    Id VARCHAR(100)
   ,C1 INT
 ...

As far as I know, there is no migration tool.

(But in all the time I've been involved with SQL Server, I've never worked anywhere that even uses SSMS projects, so...

Use STRING_AGG(). This might work (difficult to test without DDL and sample data):

SELECT distinctid = STRING_AGG(AtcCode, ',')
      ,Atc_Text
FROM dbo.Drugs_BasicData d
  ...

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

What's your point and how does...

(Please note that I have not yet performed a migration of SSISDB to 2019, so my comments are educated guesswork.)

I think you may have already identified the reason for the...

The syntax you used in your post is the syntax I would use for selecting only those rows where all three conditions are satisfied.

SELECT ...
FROM ...
WHERE condition1...

I really doubt it. Show us your WHERE clause, please, plus a sample of the data which is selected which you say should not have been.

OK, that makes it more tricky. It should be possible to extract those connection strings into a package-scoped variable, but I think you would need to add a Script Task...

Can you explain the ordering logic, please?

Something like this? It makes a few assumptions about how your data is ordered. What is the PK of this table?

WITH ordered
AS (SELECT a.enddate
   ...

OK, let's assume that the ExecutionMode parameter is set up.

Let's also assume that you have two connection string parameters set up:

ConnectionD and ConnectionM

These are passed into the package at run...

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