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, t-sql with, t-sql in, timestamp, t-sql;, SQL Server, sql server c, Sql reports, sql integration, sql import, service database , reports sql server, package, net sql server, net integration, net c# sql server, Integration server, import sql, get sql help, database calculations

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

Projekt-ID: #997717

Tildelt til:

pmansour

Kindly check your PM

$100 USD in 3 dage
(9 bedømmelser)
5.5

6 freelancere byder i gennemsnit $174 for dette job

kandiyaar

Hi , Please Check My PMB !

$200 USD in 5 dage
(14 bedømmelser)
5.0
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: [url removed, login to view]

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