Project Detail

SQL Server 2000 - SQL Server Agent - BCP Script

SQL Server 2000 - SQL Server Agent - BCP Script is project number 349537
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: crajeshbe

Budget: $30-250

Created: 11/26/2008 at 21:25 EST

Bid Count: 6

Average Bid:
$ 152

11/28/2008 at 21:25 EST

Project Creator: donhenderson1961 offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (14 reviews)

Description

Develop a SQL Server 2000 T-SQL script/stored procedure to poll a folder on the hard drive of the server SQL Server is on using SQL Server Agent, as well as other servers on the network for a csv file. If a csv file exists in the folder with the name test.csv, use bulk copy to copy the csv file contents to a table named test. Make up the columns and test data of type, int, datetime, varchar(4000) and text. Make the test csv file 500kb. If the data is successfully copied, delete the csv file. Make a log entry into a log table of major tasks and success/failure result.

Report Violation

Job Type

Windows

See more: bulk, copy, csv, data, file, make, network, poll, script, server, sql, sql server, test

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

11-26-2008 22:53 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(64 reviews)

Expert in Sql server 2000 BCP scripting, Stored procedure and triggers. Ready to start right now. Regards C.Rajesh B.E

gvyshnya offline

150

1 day

11-26-2008 23:46 EST

9.8333/10
(18 reviews)

Please see more details in PM.

cosmoinfosys offline

150

3 days

11-28-2008 02:50 EST

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(2 reviews)

Dear sir/Madam , please check PMB. Thanks , With Best regards.

ProggerGood offline

250

1 day

11-26-2008 21:57 EST

(No Feedback Yet)

Hello. Please check PMB.

shafinur offline

200

1 day

11-27-2008 00:03 EST

(No Feedback Yet)

I am MCSD, MCDBA and have vast knowledge on MS SQL Server practical experience. Plese let me allow to do the project.. Your 100% satisfaction is my ultimate goal.

zavl offline

120

1 day

11-27-2008 02:07 EST

(No Feedback Yet)

I work on SQL 2000/2005 as stored procedures/triggers developer. Last project - import images into blob fields. Import CSV is much more easily Ready to start/finish 29.11.2008

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.