SSIS package to read from Excel and insert into SQL Server
This project received 34 bids from talented freelancers with an average bid price of $193 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
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
- 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
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online