SSIS package to read from Excel and insert into SQL Server


I need a small SSIS package created that will look for, open and read from an Excel file and send the values to the DB for insert. Basic flow is below:

- launch package

- check for existance of excel file with the name of the previous date (ex: [url removed, login to view])

- if file does not exist, insert record in to table and send fail email

- exit

- copy file from \\server\folder\folder to local server

- read each line and get the values from each cell

- send the values from each row to a stored procedure to insert in to a table, returning an error code. if the error is 0, the record inserted successfully. if not, the record did not get inserted and the sproc will roll it back. keep a total of successful records.

- if error code does not equal 0, insert record in to second table and keep a total of failed records.

- close file when complete

- call a stored procedure that will insert the file name in to a table

- send email with total number of successful and failed records


- all code must have some documentation so I can make changes

- any references to file names, stored procedures, etc will need to be changed

- do NOT write the stored procedures unless you need them. I already have them so you can use place holders

Skills: Microsoft SQL Server

See more: sql server insert excel, sql server insert xml, sql server insert file, vbs sql server insert

About the Employer:
( 12 reviews ) United States

Project ID: #12208529

33 freelancers are bidding on average $187 for this job


Hello, As an expert in sql server related works as well as expert c# developer, i am very much interested to do this work by C#. Please let me know if you are interested to get this done by C# instead of SSIS. Just to More

$160 USD in 3 days
(42 Reviews)

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I h More

$200 USD in 8 days
(47 Reviews)

i have 5 yrs of experience in SQL development and MSBI technology . I will create the ssis package as per your criteria.

$170 USD in 2 days
(16 Reviews)

I have more than 7 years of experience in IT industry.I have worked on .net(c#,,mvc) with SQLSERVER 2005/2008/2012 and ORACLE(pl/sql).I can provide you best solution. Awaiting for you to describe your problem More

$250 USD in 10 days
(4 Reviews)

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 6 + years experience in .NET with C#,VB,ASP.NET MVC, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and More

$233 USD in 3 days
(6 Reviews)

I am Krunal K. Doshi from INDIA having 12+ year of experience in IT field having completed majority of projects with Microsoft Technologies. I have a team of experience programmers expertise in .NET(MVC and traditional More

$100 USD in 5 days
(2 Reviews)

I am interested..

$111 USD in 5 days
(4 Reviews)

I have recently completed same task, so please provide me your related table designs with sample data, sample excel data file for import and stored procedure. Please review my profile. More

$110 USD in 8 days
(2 Reviews)

Dear Sir, This is Sikander. I am having 14+ years of experience in software development and I have done similar kind of jobs in past I am ready to start this job. I will provide you best services in development. More

$250 USD in 3 days
(1 Review)

Dear friend, I have good experience in building SSIS packages that performs automated tasks in the sql server. I have implemented and a number of ETL projects for my clients and it will be easy go for me. I have More

$250 USD in 5 days
(1 Review)

I done this package using ssis with excel

$66 USD in 1 day
(1 Review)

I will create SSIS package for you. I have read the details and willing to do work with you. Feel free to contact me for further discussion. Regards, Moeen Ahmed

$120 USD in 10 days
(1 Review)

Hi there, I have good experience with SSIS, Excel, SQl Server for data transformation, developing SSIS packages, deploying packages and more. I have done this work for a USA based client and can give th More

$55 USD in 4 days
(0 Reviews)

I have two years of expereince in SQL and MSBI. Will try to complete the project as soon as possible

$200 USD in 3 days
(0 Reviews)

I'm free to do this tonight. I have developed SSIS/MSSQL/.NET packages since their inception. This is about a $2000 project but I will do it for $500 if we can do it in a straight-forward manner and tonight. I'm in More

$556 USD in 3 days
(0 Reviews)

I have vast experience on SSIS and will be able to deliver this faultlessly

$177 USD in 4 days
(0 Reviews)

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)

i'm a senior database developer for 17 years.

$222 USD in 5 days
(0 Reviews)

I do this type of conversion from excel to SQL lot of times. This is very easy. provide documentation and configuration flexibility.

$111 USD in 2 days
(0 Reviews)

Hello Hiring person, I have gone through your reuqirement. I am expert in ETL work and having 5 yrs (Total 8 yrs) of experience in MSBI technologies such as SSIS, SSRS & SSAS. In ETL, I have worked in many types of fi More

$194 USD in 7 days
(0 Reviews)