Find Jobs
Hire Freelancers

Creating Advanced SQL/TSQL Queries for MS SQL Server 2008 R2

$30-250 USD

クローズ
投稿日: 約12年前

$30-250 USD

完了時にお支払い
This project was previouslty posted but never completed: I need to developed advanced queries for MS SQL/TSQL Server 2008 R2. I need queries that gets records from two or more linked tables from an Oracle Database that share relationships. The query gets the records and places the record in a new table, I will call the new table local table for simplicity sake. Than the query runs everyday at a certain time (designated) gets new records from the link tables and place them in the local table. Here is where it gets important. When the query runs daily, it updates any record that has been changed in the link tables, so if a person address changes, the address is updated in the local table. If there are no new records or updated records in the link table, nothing is brought over. If there are new records, they are brought over. Finally I need all the data queried from the local table exported as a CSV file to a specific directory or to a server via FTP. All this needs to happen sequentially, and automated through SQL SSIS and BID. I need this clean and easy to understand. Only serious and honest bidders.
プロジェクト ID: 1385123

プロジェクトについて

55個の提案
リモートプロジェクト
アクティブ 12年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に55人のフリーランサーが、平均$169 USDで入札しています
ユーザーアバター
10 years of experience in database architecture design, administration. specialized in replication management. please check PM
$150 USD 20日以内
5.0 (26 レビュー)
7.1
7.1
ユーザーアバター
Please see PMB.
$200 USD 2日以内
4.7 (11 レビュー)
5.2
5.2
ユーザーアバター
Hi! I have 12 years experienace in MSSQL. I understand what do you want. I did it many time with Access, FileMaker and etc. If you alredy have oreacle - linked I can did your task. Export to cv on local file is a peace of cake. For each table you must have primary field(s). Regards.
$250 USD 3日以内
4.5 (12 レビュー)
4.4
4.4
ユーザーアバター
Hi, I have been working as an IT contractor for 20+ years, with the last 10 years specialising in database and business intelligence development across SQL Server (SSRS & SSIS), Oracle and Business Objects. I will provide all source code along with documentation.
$200 USD 5日以内
5.0 (1 レビュー)
3.2
3.2
ユーザーアバター
I have gone through the requiremtns. Your project matches 100% with my expertise. I am very much familiar with SQL Server, SSIS and BIDS. I have years of experience with this technologies. I have discussed more in PM.
$250 USD 10日以内
4.5 (4 レビュー)
3.2
3.2
ユーザーアバター
Hello once again. As we noticed before we are very familiar with SQL queries. Please check your inbox for examples.
$180 USD 2日以内
5.0 (2 レビュー)
2.6
2.6
ユーザーアバター
I have many years experience doing this I can create one stored proc to do this that can be launched through SSIS or SQL Agent see PM
$200 USD 7日以内
5.0 (1 レビュー)
2.6
2.6
ユーザーアバター
A SSIS solution can be developed for this in a number of ways.
$200 USD 3日以内
3.6 (6 レビュー)
3.8
3.8
ユーザーアバター
Hello Sir, I had 3 years of experience working on ETL solutions using SSIS. I have been working on the similar ETL project currently. I had very clear idea on the solution. Please see PM for more details. Regards, MadhuSolutions
$150 USD 5日以内
5.0 (1 レビュー)
2.0
2.0
ユーザーアバター
Hi, I have good experience in SQL Server and SSIS . Please read the personal message below.
$75 USD 10日以内
5.0 (1 レビュー)
1.4
1.4
ユーザーアバター
Hi, I am a database administrator in SQL server(Microsoft Certified). You can check my profile. This is a basic task. Can complete this easily. But I have few questions? 1) Will you give web console access to server or computer at which i have to create SSIS packages? 2) There is other option to get this job job done (without SSIS, this will make edits eaily , i.e., if you wish to change source and destinations) Waiting to hear from you. Thanks in advance Naveen
$65 USD 1日以内
4.6 (2 レビュー)
1.6
1.6
ユーザーアバター
Hello, Please look at PMB. Best Regards, Vin
$150 USD 3日以内
5.0 (1 レビュー)
1.0
1.0
ユーザーアバター
Please check your PMB
$200 USD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Within ONE day completion and delivery with high quality is GUARANTEED !!!
$50 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Dear Sir, Please check PMB for details.
$200 USD 15日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I am very proficient in SQL,Oracle and SQL Server. I have categorized your requirement in steps. 1) Connecting Oracle from SQL server (Prerequisite access to both the environment) 2) Querying Oracle db using Sql server(information required oracle table details and filter criteria if any need to be applied in query). 3)Creating local Table in SQL Server. 4)Updating and inserting Data in SQL server local Table. 5)Running the Process as scheduler. 6)exporting the data in csv and uploading that in folder location. Step 5 and 6 can be done easily in java. let me know if that's is OK with you, i can create a batch job that will run java program as per schedule.
$130 USD 15日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi Syndrome, I am an professional Business Intelligence developer,I have done so many projects and where i have extracted data from DB2, ORACLE, Informix and so many other data sources on windows x64 and x32 environments. I hope i can done your project well.
$70 USD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have been doing this kind of SSIS Packages for last two years..So I can do this job very efficently..and definitly you will be satisfied with my work..Please go through my attached documents which i have sent in the private message...
$75 USD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have good experience in SQL Server, Oracle especially with data transfer, conversion, ETL etc.
$250 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I am an expert in SQL server working for past 10 years. I can help you get your work completed.
$150 USD 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Brooklyn, United States
0.0
0
お支払い方法確認済み
メンバー登録日:12月 19, 2011

クライアント確認

このクライアントからの他の仕事

Creating Advanced SQL/TSQL Queries and Macros
$30-250 USD
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。