Sedang Disiapkan

SQL Server 2000 - SQL Server Agent - BCP Script

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 [url removed, login to view], 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.

Kemahiran: Destop Windows

Lihat lebih lanjut: bcp sql server, sql server agent bcp, bcp sql server 2000, sql server agent job bcp, sql 2000 bcp, stored procedure sql bcp, sql server 2000 bcp stored procedure, sql server 2000 bcp, sql agent bcp, ultimate day sql server script, bcp sql2008, bcp import sql server 2000, sql server 2000 sql server agent copy files, script job sql 2000, sql server bcp examples, sql server 2000 copy agent job, sqlserver agent visible, bcp sql server 2005 sql server 2000, sql server bcp csv file, sql bcp copy table sql 2000 sql 2005, bcp sql server 2008, sql server 2005 bcp scriptsql, sql server 2000 agent visible, pmb sql server 2008, bcp sql server job

Tentang Majikan:
( 46 ulasan ) McKinney, Canada

ID Projek: #349537

Dianugerahkan kepada:

crajeshbe

Expert in Sql server 2000 BCP scripting, Stored procedure and triggers. Ready to start right now. Regards [url removed, login to view] B.E

$40 USD dalam sehari
(12 Ulasan)
4.1

6 pekerja bebas membida secara purata $152 untuk pekerjaan ini

cosmoinfosys

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

$150 USD dalam 3 hari
(1 Ulasan)
2.6
gvyshnya

Please see more details in PM.

$150 USD dalam sehari
(1 Ulasan)
1.6
ProggerGood

Hello. Please check PMB.

$250 USD dalam sehari
(0 Ulasan)
0.0
shafinur

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.

$200 USD dalam sehari
(0 Ulasan)
0.0
zavl

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 [url removed, login to view]

$120 USD dalam sehari
(0 Ulasan)
0.0