Automation of Daily CSV File Import Process

Sample Files

 

Table creation script

USE [DEMO]
GO

/****** Object:  Table [dbo].[Products]    Script Date: 25/07/2025 09:40:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Products](
    [id] [int] NOT NULL,
    [NAME] [varchar](50) NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


 

Could you please share the .ats project file with us? We would like to modify it as part of our business requirements.

The mapping is stored in the repository (backup.zip file).

You already have it

Did you restore the repository?