Closed

SQL Script to import XML file data

This project received 24 bids from talented freelancers with an average bid price of $80 AUD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
24
Project Description

Hi,

I would like someone to take the following table in SQL 2005

USE [SPData]
GO
/****** Object: Table [dbo].[SFTPMonitor] Script Date: 05/15/2013 14:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SFTPMonitor](
[SFTPConname] [nvarchar](50) NULL,
[SFTPExecuteDate] [datetime] NULL,
[SFTPFolder] [nvarchar](50) NULL,
[SFTPFilename] [nvarchar](50) NULL,
[SFTPType] [nvarchar](50) NULL,
[SFTPCreated] [datetime] NULL,
[SFTPSecurity] [nvarchar](50) NULL,
[SFTPSize] [numeric](18, 0) NULL,
[SFTPSuccess] [nvarchar](50) NULL
) ON [PRIMARY]

And write a SQL script that will import an XML file with data in the attributes of the XML tags.

I will send you the XML file, the resulting table in excel as an example of the end result and the table for the XML to be imported into is as above.

I need this script writing today ASAP and am willing to pay a flat rate.

Please respond with best offer and what experience you have in writing SQL scripts importing XML files into tables.

I will pay $30 when I can run the SQL script on my server.

No access to remote server, you must have access to SQL 2005 yourself to develop this script.

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

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