Completed

Create a SSIS project to import csv files to SQL Server 2016

To create a repeatable ssis project to pull in 8 csv files into SQL Server into a single [login to view URL] an audit table recording how many rows in the source and how many pulled in to the destination from each csv file.

Source sample files attached.

All source files have the same schema.

The destination tables to populate are:

1. CREATE TABLE [dbo].[AA_Veronis_All](

[ID] [int] IDENTITY(1,1) NOT NULL, --PK

[SourceFilePath] [varchar](max) NULL, -- A variable in ssis that defines where to pick up the source files from

[SourceFile] [varchar](max) NULL, --Actual source File Name

[RunID] [int] NULL, --Each run of the ssis package to look at the max(runid) from this table and add 1

[Access_Path] [varchar](max) NULL, -- 1st column of source file

[File_Server] [varchar](max) NULL, -- 2nd column of source file

[User_Group] [varchar](max) NULL, -- 3rd column of source file

[Logon_Name] [varchar](max) NULL, -- 4th column of source file

[Current_Permissions] [varchar](max) NULL, -- 5th column of source file

[Owner_Name] [varchar](max) NULL, -- 6th column of source file

[Account_Type] [varchar](max) NULL, -- 7th column of source file

[InsertedDate] [datetime] NOT NULL, -- defaults to getdate() to capture the date/time the row was inserted

CONSTRAINT [PK_AA_Veronis_AllUsers] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[AA_Veronis_All] ADD CONSTRAINT [DF_AA_Veronis_AllUsers_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]

GO

2. CREATE TABLE [dbo].[VerAudit](

[RunID] [int] IDENTITY(1,1) NOT NULL, --pk identity field

[SourcePath] [varchar](max) NULL, -- audit the source path for each run of ssis package

[SourceFile] [varchar](max) NULL, -- audit the source file for each run of ssis package

[RunDate] [datetime] NULL, -- audit the run date for each run of ssis package

[SourceRowCount] [int] NULL, -- audit the number of rows in the source file

[DestinationRowCount] [nchar](10) NULL, -- audit the number of rows actually inserted from the source file

CONSTRAINT [PK_VerAudit] PRIMARY KEY CLUSTERED

(

[RunID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Skills: SQL, Microsoft SQL Server, SSIS (SQL Server Integration Services), Business Intelligence

See more: import csv data sql server table, aspnet import csv file sql server, import csv file sql server 2005 database, ssis import text file to sql table, ssis import multiple csv files, sql create table from csv, import data from csv to sql server using query, how to load multiple comma delimited files to sql server table in ssis package, ssis package to import csv files into sql server database, import data from flat file to sql server using ssis, import csv file into sql server using stored procedure, import csv file sql server, import wizard importing csv files sql server 2005, import csv file sql server 2005 express dts, import csv file sql server management studio express, import csv files sql 2005, import csv files sql server 2005 wizard, import xml files sql server 2005, import csv file sql server express 2005, free source code import csv data sql server net windows service

About the Employer:
( 32 reviews ) London, United Kingdom

Project ID: #27821489

Awarded to:

ShafirR

Hi ! When viewing your jobs details, it really jumped out at me. In my current Professional Microsoft SQL Server DBA role, I have extensive experience with Developing SSIS package to import csv files to SQL Server 201 More

$30 USD in 1 day
(5 Reviews)
3.2

9 freelancers are bidding on average $52 for this job

akshaybhagwat76

hi there! i will create that project that will pull info from csv and transfer data in sql. i can start this now.

$73 USD in 1 day
(6 Reviews)
4.7
SqlDevelopment

I can qualitatively develop a required SSIS package. I am Senior SQL Developer with 10+ years of professional experience and having exceptional expertise in Integration Services development.

$120 USD in 2 days
(22 Reviews)
4.1
sreenivas2903

Hello I am expertise in etl processing and sql server . I have processed multiple file formats and using very optimized technique. if you are really looking for quick fix and resolve the issue. ping me we will finish i More

$56 USD in 1 day
(18 Reviews)
4.4
aap31374

I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way. I More

$56 USD in 1 day
(5 Reviews)
3.3
anandan1995

I have a experience in asp.net, MVC, web API,Laravel,Php,,Java, Spring mvc,Hibernate, c#, SQL, entity framework,linq, razor view (Cshtl), html, Wordpress,Joomla,Shopify,Jstl,bootstrap,Angular JS, Jquery, Json,XML, repo More

$30 USD in 1 day
(11 Reviews)
3.1
lazrodrigue

Hello, my name is Elom, i am I am core SQL Server Production DBA with more than 10 years of experiences. My background: - strong knowledge of relational databases, skills in SQL query design and development. - 5+ year More

$50 USD in 7 days
(2 Reviews)
1.5
usmanashraf1

Hi, I have read your requirments, it's pretty amazing and interesting job for me because recently i have done a project related to Data Management. The appliaction Import data from excel file, translate data from Engl More

$25 USD in 3 days
(0 Reviews)
0.0
leiyonz

Leave a message if you want me to do it, then I can show you some result within few hours Bring it on... I have been playing with: Data Warehouse | ETL | Business Intelligence | Analytics | Data Insights | Database More

$25 USD in 2 days
(0 Reviews)
0.0