Deliver SQL Server 2k DTS/SQL Server 2005 SSIS package that does the following:
1) Look for a [url removed, login to view] file in a folder named c:test on the server SQL Server is on, and another server on the network.
2) If the file exists, copy the data to a table named test.
3) Have several columns in the [url removed, login to view] file: varchar(10), varchar(4000), int, bit, datetime, text.
4) Make [url removed, login to view] 500k.
5) Log that a file was found and log the time. Log that is was successfully copied and the time. Log any errors and the time.
6) delete the [url removed, login to view] file only if the upload was successful.
16 pekerja bebas membida secara purata $175 untuk pekerjaan ini
We are a group of software developers having more than 5 years of experience in sw developement we believe in providing high quality solutions in promised deadlines