I'd still lean towards looking to buy some other CRM tool versus build your own.

Based on what you've (the OP) posted so far, I'd agree with this. I used to...

Is the scope of this work as follows?

1. Build a SQL Server database which matches your existing database
2. Migrate existing data to new database
3. Replicate existing Zoho CRM application functionality

...

SELECT o1.*
FROM OrderItem o1
WHERE NOT EXISTS (SELECT 1 FROM OrderItem o2 where o1.OrderId = o2.OrderId and o2.Status <> 'Shipped')

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