176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

SQL Server 2008R2 SSIS (Integration Services) Project
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Nov 02, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

SQL Server Integration Services (SSIS) Package

An outline of the requirements is as follows.

I need two databases to be copied from one server to another on a regular basis.

The first database is created on a monthly basis on SERVER_A. SERVER_A is a SQL Server 2000 box and any connection must be via mixed mode authentication.

This database has the always has the same name plus a suffix to denote the month in question. The query

select top 1 Name from master..sysdatabases where name like 'SalesData%' order by crdate desc

will provide the name of the database in question.

Additionaly, another database on SERVER_A called "Database2" is to be copied if and only if a new version of "SalesData%" has been copied.

These databases are then to be copied to SERVER_B. SERVER_B is a SQL 2008R2 box.

The package is to be deployed to SERVER_B.

Passwords are to be stored in configuration files which will be saved on SERVER_B.

The job is to be run manually. If the latest 'SalesData%' data...

Sign in or Register to see more

Job ID: 26893176
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Viertech is a pri­vately owned IT Con­sult­ing and Inte­gra­tion com­pany spe­cial­ized in imple­men­ta­tion and opti­miza­tion of com­plex...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 27099795  |  Submitted: Nov 15, 2011 12:00 ET 
Proposal SEALED

 India  |  
• Having 8.10 Years of Total IT Experience and strong 8 Years of experience in Microsoft Business Intelligence Technologies (SQL Server, SSIS,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 26977920  |  Submitted: Nov 8, 2011 02:38 ET 
Proposal SEALED

 Croatia (Hrvatska)  |  
I am an experienced SQL Server Developer with 9 years of SQL Server experience. Last 5 years I worked solely as a SQL Server developer and...
4
  |  
 5.0   |  Private   |  0 Jobs
Bid ID: 26954869  |  Submitted: Nov 6, 2011 17:25 ET 
Proposal SEALED

Temple City Technologies (p)Ltd.,(TCT) is a premiere Software Development concern, with a group of software professionals in IT industry over the...
3
  |  
 4.4   |  Private   |  26 Jobs
Bid ID: 26950259  |  Submitted: Nov 6, 2011 07:01 ET 
Proposal SEALED

 Australia  |  
To whom so ever it may concern, I have 4+ years of IT industry experience with .net and Microsoft Business Intelligence technologies. Would like...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 26901848  |  Submitted: Nov 2, 2011 20:33 ET 
Proposal SEALED

 Latvia  |  
http://biassistance.com I'm Certified Business Intelligence consultant with more than 8 years of experience with BI solutions and database...
4
  |  
 4.8   |  Private   |  6 Jobs
Bid ID: 26898587  |  Submitted: Nov 2, 2011 15:39 ET 
Proposal SEALED

 Belgium  |  
13 years of experience as a SQL Server DBA and Business Intelligence developer at multinationals like: -BNPP Bank in Brussels -Schroders Asset...
11
  |  
 5.0   |  Private   |  16 Jobs
Bid ID: 26897445  |  Submitted: Nov 2, 2011 14:33 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »