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.
6 pekerja bebas membida secara purata $152 untuk pekerjaan ini
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.
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