The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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