Ukončen

SSIS package to read from Excel and insert into SQL Server

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

Dovednosti: Microsoft SQL Server

Zobrazit více: sql server insert excel, sql server insert xml, sql server insert file, vbs sql server insert

O zaměstnavateli:
( 12 recenzí ) United States

IČ projektu: #12208529

32 freelancerů učinili na tento projekt nabídku v průměrné výši $189

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 Více

$160 USD za 3 dní
(55 recenzí)
6.5
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 Více

$200 USD za 8 dní
(53 recenzí)
5.8
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 za 2 dní
(16 recenzí)
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 Více

$250 USD za 10 dní
(17 recenzí)
4.4
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 Více

$233 USD za 3 dní
(6 recenzí)
3.5
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. Více

$250 USD za 3 dní
(2 recenzí)
3.2
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 Více

$110 USD za 8 dní
(9 recenzí)
3.3
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 za 10 dní
(7 recenzí)
3.2
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 Více

$100 USD za 5 dní
(2 recenzí)
2.7
scsBiswas

I am interested..

$111 USD za 5 dní
(4 recenzí)
2.4
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 Více

$250 USD za 5 dní
(1 recenze)
1.2
arvind19821

I done this package using ssis with excel

$66 USD za 1 den
(1 recenze)
1.0
dhruvsharma14

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

$200 USD za 3 dní
(0 recenzí)
0.0
stukrish

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

$177 USD za 4 dní
(0 recenzí)
0.0
sunshinelabs

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 Více

$556 USD za 3 dní
(0 recenzí)
0.0
laupiais

A proposal has not yet been provided

$155 USD za 3 dní
(0 recenzí)
0.0
warlleylucas

i'm a senior database developer for 17 years.

$222 USD za 5 dní
(0 recenzí)
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 za 2 dní
(0 recenzí)
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 Více

$194 USD za 7 dní
(0 recenzí)
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 Více

$55 USD za 4 dní
(0 recenzí)
0.0