Error with DATABASE insert Activity

@Sugumar8785
you can do one thing …create store Proc for that and use Execute Non Query activity

CREATE PROCEDURE [dbo].[Insert_Customers]
@tblCustomers CustomerType READONLY
AS
BEGIN
SET NOCOUNT ON;

  INSERT INTO Customers(CustomerId, Name, Country)
  SELECT Id, Name, Country FROM @tblCustomers

END

1 Like