1. Change the ResultSet property of your ExecSQL task to 'Single Row'
2. Select the Result Set node of the ExecSQL task and click on Add

   1. Set Result Name to 0...

I would guess that it's because ProductName is not unique in the table

Try changing your match criteria from this

(TARGET.ProductName= SOURCE.ProductName)

to this

(TARGET.ProductId= SOURCE.ProductId)

• This reply was modified 6 years, 6 months ago by Phil Parkin. Reason: Fix typo

You don't need to use VALUES when selecting from one or more tables.

INSERT t(col1, Col2)

SELECT t1.Col1, t2.Col2

FROM t1 join t2 ...

'Quater' ... do you mean 'Quarter', by any chance?

Not sure I understand: are you trying to set the value of an SSIS package variable to the 'QuaterID' which the above...

Good response. I'd help if I could, but I'm just a lowly developer 🙂

Do you want the new tables to be empty?

There's no need to have such an unpleasant attitude. People on this forum are generally friendly and helpful. You'll get the best responses if you are too.

Instead of providing us with a list of requirements and forcing us to play "guess the question", why not ask us something specific?

Can you provide a bit of background as to why you want to do this?

Seems like it will create a lot of clutter in your DB ... others here may...

One thing I've learned through experience is not to use the word 'new' in any object names. It may seem like a good idea now, but in three years' time...

Phil... thanks for that as actually it is copying the table and keeping the same name with _new added.  So for the mis hap..will correct my self in the...

Work out the syntax for renaming a single table and then write some T-SQL which queries sys.tables & constructs that T-SQL for all tables, as a SELECT.

You can then cut...

If you are using SQL 2016 or onward version then go for Temporal Tables to maintain the history. This is something new inbuilt feature as far as Audit Log/History...

Like this?

DROP TABLE IF EXISTS #t1;

CREATE TABLE #t1
(
    c1 INT
);

INSERT #t1
(
    c1
)
VALUES
(2  )
,(11)
,(4)
,(9);

SELECT t.c1
      ,c2...

Here's another idea:

In the Execute SQL Task, can we check to see if the parameter has a null value?  If it does, then we can SELECT the max(date).  If...