Lezárt

SSIS package to read from Excel and insert into SQL Server

A projektre 35 árajánlat érkezett képzett szabadúszóinktól, az átlagos ajánlat a következő volt: $190 USD.

Kapjon ingyenes árajánlatokat egy hasonló projektre
A munkaadó dolgozik
Projekt költségvetés
$30 - $250 USD
Összes Árajánlat
35
Projekleírás

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

Szükséges készségek

Szeretne pénzt keresni?

  • Adja meg a költségvetést és a munkaelvégzéséhez szükséges időt
  • Vázolja fel ajánlatát
  • Kapjon fizetést munkájáért

Alkalmazza a szabadúszókat, akik erre a projektre is ajánlatot adtak

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online