Closed

SQL Script to import XML file data

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.

Skills: SQL, XML

See more: import xml sql server, script xml file sql, sql experience, xml excel, sql server scripts, sql script , script writing, create file table access, import flat table, excel create xml, flat file access, sql server access excel, create xml access table, sql server script import, excel access import data, excel sql create, xml file excel, script run access sql, excel import access, script import, script excel sql, import result, rate table excel, sql script import excel, excel import data access

About the Employer:
( 0 reviews ) Australia

Project ID: #4522199

22 freelancers are bidding on average $84 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$206 AUD in 5 days
(28 Reviews)
5.9
weonlydo

SQL Server expert from across the ditch. I can do this very quickly and efficiently. Please check references in PM.

$34 AUD in 1 day
(14 Reviews)
4.7
feninsoftech

Hi, This can be achieved by OPENXML in SQL Server. I have 8 years experience in SQL Server development.

$111 AUD in 3 days
(6 Reviews)
4.0
kalpesh2804

Hello, I can provide you solution using .net

$30 AUD in 3 days
(9 Reviews)
3.8
manask1703

Hi I am expert in conversion of DB. Thanks Krishna

$88 AUD in 3 days
(3 Reviews)
2.7
sqlservercoder

This is Baskaran Selvaraj and have worked for various clients like Amway, Mellon Group for past 15 years as Database Administrator & Application developer. Achieved Microsoft Certifications in Microsoft SQL Serve More

$66 AUD in 1 day
(3 Reviews)
2.4
srdas2012

Hi We have vast Experience in the Similar Converstion We are Expert,Please see PMB

$59 AUD in 2 days
(1 Review)
1.7
jayshreeganeshha

hi i am excellent in sql i would like to work on your [url removed, login to view]

$35 AUD in 1 day
(1 Review)
1.5
softdir

Hi There, Please see PMB.

$150 AUD in 1 day
(2 Reviews)
1.3
CassaTech

I have worked and currently work extensively with XML loads directly. The solution I would provide would load the data directly from the XML file into the SQL Server table using a bulk load mechanism. My technical so More

$88 AUD in 1 day
(0 Reviews)
0.0
SonNTz4

Hi, I Can help you. And I am ready to start

$40 AUD in 3 days
(0 Reviews)
0.0
sagarwal448

Hi. I have 6+ years of exp in SQL server and SSIS packages. I have also worked on migrations applications along with the databases (both 2010 and 2012) with some of the leading companies of the world. Given a chance, I More

$147 AUD in 1 day
(0 Reviews)
0.0
vack

Hi, I am experienced with SQL Server 2005 and currently with 2008 for 2 years and used to do this kind of work for a Product based Cloud Computing company.

$30 AUD in 3 days
(0 Reviews)
0.0
pandyamunjal

Dear Sir, We can do that in a day. Thanks, Munjal

$35 AUD in 1 day
(0 Reviews)
0.0
kamtrivedi

What, This is dam easy. I can do in in less than 1 day. Send me the XML.

$111 AUD in 3 days
(0 Reviews)
0.0
gununandini

Hi Dear, I have 3 years of experience on sql server writing scripts, ssis packages to upload excel. xml files. You can count on me regarding this. For more communicatin please add me on skype. lilima.baisak. Look More

$211 AUD in 3 days
(0 Reviews)
0.0
lymonedesigns

worked with importing XML into SQL Server and MySQL. straightforward.

$30 AUD in 2 days
(0 Reviews)
0.0
jvpolivares

Hi, SQL developer, I write the SQL script for you. Best regards, Juanvi

$35 AUD in 1 day
(0 Reviews)
0.0
gjinfotech004

I am having 5+ year experience in sql server, pl/sql and c# language . . . i can do this work.

$111 AUD in 1 day
(0 Reviews)
0.0
sathishviji

Hi, I have 6+ expr in SQL. And I do have ms 2005 as well as ms 2008. So no need for remote server connection. I can complete your request in <2-3 hrs. Please provide this project to me

$30 AUD in 1 day
(0 Reviews)
0.0