Find Jobs
Hire Freelancers

Creating SSIS packages for import and export thro' excel and run it using application

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
Hello, I need a person with skills in SSIS (SQL Server integration Services) and Visual C#. I want to create C# application which should run 6 different SQL queries/views from SSIS package based on button click (button 1 will execute dataflow 1, Button2->dataflow2...etc). I want to perform import (excel source to SQL database) & export tasks (from same SQL DB source to excel destination). This data should be updated or appended based on it's existence. At the end SSIS package should display options to save or discard the changes done in import package (excel source to SQL destination). I need it urgently in 3 days so please only bid if you can finish it in 3 days. Thanks.
Project ID: 6842334

About the project

13 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Sir, I have readymade solution for upload CSV / Excel file using SSIS / ASP.net . also its include SSRS reports / data grid to display import log / imported data summary on asp.net webpage. Please share the available MS SQL server version and the asp.net availability . along with the sap le data for and destination table structure SQL script we might need to create staging table . and log tables for the as required . I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$55 USD in 3 days
4.9 (73 reviews)
5.7
5.7
13 freelancers are bidding on average $161 USD for this job
User Avatar
hi. I have 2 years experience in C#. I have worked a lot with databases (MySQL, MS-SQL etc). I have already done SSIS projects. here's the link to my completed SSIS project: ---(https://www.freelancer.com/projects/C-Sharp-Programming-microsoft-sql-server/SSIS-project-connect-OAUTH-web.html)--- I'm very interested in your project and I have the skills to do it quickly for you. we can discuss further before we begin. let's do it. hope to have a good business with you :) waiting for your response...
$250 USD in 4 days
5.0 (162 reviews)
7.6
7.6
User Avatar
Dear Client, It's Ram, From India. I read out the description to create an application using SSIS and C# and to write queries on buttons to perform relevant actions and at the end to save or discard the changes made. I am highly experienced in the database queries and tasks and have been using C# & SSIS from more than 6 years, So the requirements completely matches to my competency. I am ready to work on this project. Please check my profile and work portfolio at following freelancer.com url- https://www.freelancer.com/u/digidreamstech.html Waiting for your reply. Thanks & Kind Regards, Ram
$97 USD in 3 days
4.7 (37 reviews)
6.3
6.3
User Avatar
I will use C# and dts runtime assembly to execute importing data into sqlserver and openxml to export data to excel file. I have done many similar projects before. I can deliver it for you in 3 days. Please refer my previous projects for your information.
$222 USD in 3 days
5.0 (26 reviews)
5.7
5.7
User Avatar
Hi, I have more than 5 year experience in SSIS and T-SQL. I think i am the right person for your task. I worked a lot on this and surely I will complete it within 3 day .
$186 USD in 3 days
4.9 (50 reviews)
5.8
5.8
User Avatar
Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application (OSS & BSS Rating and Billing), Financial Application, ERP-Application, and School Application, Central and State Govt. Offices application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, MVC, Entity Framework, Visual Basic, Crystal Report, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, DurandalJS, etc all advanced technologies. I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.
$250 USD in 3 days
4.8 (15 reviews)
3.2
3.2
User Avatar
I am a talented C# Developer with years of experience and educational training. I am willing to work as a team member and also autonomously for your project. I have also worked for many years of my career as a ASP.NET/EF5 with sql server . If hired by you I will deliver my best work at a high standard. I look forward to being hired by you for your jobs.
$155 USD in 2 days
4.9 (5 reviews)
3.2
3.2
User Avatar
Предложение еще не подано
$205 USD in 3 days
5.0 (4 reviews)
2.9
2.9
User Avatar
Hello Have great experience in SSIS package building. To do job best i have some question. 1) what version of SQL server do you have (its great difference between 2005, 2008 and 2012 SSIS versions) 2) is DB and SSIS situated on one server ? 3) if i understand right SSIS packages makes two types of job - start queries and export-inport data. What type of Excel files do you have - just table or some of special formating? How much excel templates do you have? 4) What kind of application do you need - WindowForms with buttons - will be ok? Connecting strings in config file or in application interface. 5) SSIS packages are allready existing or i need to create them? 6) Have you testing DB there i can easily test queries and SSIS tasks? I can make in two three days if we can prepare good environment - RDP with installed Visual Studio and SQL Server Managment Studio will be the BEST! PS: Sorry for mistakes in text. Please skype me at dexter_alex_84
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I believe in giving bug free solution having all the business logic covered. In short, Give me your requirement, take the solution at one go. I am having around 4 years of SQL server experience in reputed IT Firms. I have been doing different kind of SSIS projects. Also, I am having Database administrator knowledge- so at the time of real deployment, my experience will come into play. waiting to hear back from you. Regards, Samarendra +91 9679920777
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I've complete 3 years experience in ssis and SQL development . So I m the best match for this project
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hamilton, United States
5.0
16
Payment method verified
Member since Nov 21, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.