SSIS package to read from Excel and insert into SQL Server

Closed

Hi,

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

COMMENTS:

- 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: insert sql server ado excel, sql server insert excel, vbnet sql server insert xml, asp net sql server insert xml, sql server insert xml document, sql server insert file xml, sql server insert file field, sql server insert xml, sql server insert file, sql server insert xml net, sql server insert xml file database, vbs sql server insert, convert sql server bak excel, sql server insert xml database

Project ID: #12208529

33 freelancers are bidding on average $187 for this job

sumon355

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)
5.7
mpalgeo

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)
5.7
ashupathania

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)
4.9
jagdishbhatt38

I have more than 7 years of experience in IT industry.I have worked on .net(c#,asp.net,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)
3.7
vinod150987

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)
3.4
mrkrunaldoshi

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)
2.7
scsBiswas

I am interested..

$111 USD in 5 days
(4 Reviews)
2.4
vw7590795vw

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. https://www.freelancer.com/u/vw7 More

$110 USD in 8 days
(2 Reviews)
1.8
sikandermandal

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)
1.6
arvind19821

I done this package using ssis with excel

$66 USD in 1 day
(1 Review)
1.0
p9technologies

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)
1.1
moeenahmed21

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)
0.6
dhruvsharma14

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)
0.0
$111 USD in 3 days
(0 Reviews)
0.0
akhileshgandhi

Hello As per your post ,I have understood your requirement. We are a team of 25 providing expertise software solutions extensively with .Net development. For more details about us you may like to visit our webs More

$238 USD in 3 days
(0 Reviews)
0.0
stukrish

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

$177 USD in 4 days
(0 Reviews)
0.0
dotnetabacus

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)
0.0
ankurdsharma

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)
0.0
warlleylucas

i'm a senior database developer for 17 years.

$222 USD in 5 days
(0 Reviews)
0.0
dotnetmechanic

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)
0.0