I gang

SQL Server Integration Service - 2005 Package

Develop a SQL Server Integration package which performs the following steps:

1. Look a config Database user table to get following values,

a. url and parameter value, e.x: URL record = "www.assda.com/asdads=", parameter: "help"

b. Scheduled time

c. Directory path

2. Concatenate the url, e.x: "www.assda.com/asdads=help"

3. Download files for each record of url in config at a specific time ("Scheduled time" stored in config) for each url in a specific directory as per config table, if direcory does not exist create one and filename should contain timestamp

4. Log succesful download, unsuccessful download onto hard drive

5. Read file content and import the file into database, the CSV files first colum is the same as table name

6. import records where dates don't exist in the database table

7. Log sucessful imports and start date and end date of records imported

8. Log failures with ability to determine the cause of failure of the file

as a next project: there will be calculations and reports required in each table, between tables

Færdigheder: .NET, C# Programmering, PHP, Software Arkitektur

Se mere: sql get date, service first, service 5, file download service, 5 service, package sql server, timestamp, sql reports, sql integration, service database , reports sql server, Package, net integration, integration server, get sql help, database calculations, concatenate, server log, csv import sql server, user integration, sql required, php database service, sql server database project, help package file, concatenate php

Om arbejdsgiveren:
( 3 bedømmelser ) Truganina, Australia

Projekt-ID: #997717

Tildelt til:

pmansour

Kindly check your PM

$100 USD in 3 dage
(10 bedømmelser)
5.6

7 freelancere byder i gennemsnit $185 for dette job

kandiyaar

Hi , Please Check My PMB !

$200 USD in 5 dage
(13 bedømmelser)
5.0
narinderbti

Please provide more details. Kindly check PMB for portfolio. Warm Regards Team ViewOmega.

$250 USD in 4 dage
(6 bedømmelser)
3.4
hireme11

I'm a SQL expert. Please see PM.

$100 USD på 1 dag
(5 bedømmelser)
3.0
sumithxp

This is can be done .Pls contact me asap. thz

$145 USD in 3 dage
(0 bedømmelser)
0.0
kishore2903

Will do it your project. But the requirement is not clear. Please provide complete information of url and other specifications. Regards.

$300 USD in 21 dage
(0 bedømmelser)
0.0
Evolex

6+ years of experience with the Microsoft Business Intelligence stack. Complete CV you can find here: https://docs.google.com/View?id=dcbsv9jv_150rpdqd7dn

$200 USD in 3 dage
(0 bedømmelser)
0.0