SSIS package to read from Excel and insert into SQL Server

Hello, As an expert in sql server related works as well as expert c# developer, i am very much interested to do this work by C#. Please let me know if you are interested to get this done by C# instead of SSIS. Just to confirm you: everything you need as described in the project, i can do by c# and you can run it in background like in scheduler or even if you want i can develop a windows service program. Thanks

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

I have more than 7 years of experience in IT industry.I have worked on .net(c#,asp.net,mvc) with SQLSERVER 2005/2008/2012 and ORACLE(pl/sql).I can provide you best solution. Awaiting for you to describe your problem so I can give you best solution right away :).

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 6 + years experience in .NET with C#,VB,ASP.NET MVC, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTML.

I have recently completed same task, so please provide me your related table designs with sample data, sample excel data file for import and stored procedure. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 4.2 years experience in SSRS, SSIS and 7 years experience in SQL. Please let me know more details and when will we start. Skype: jikenjd

Dear Sir, This is Sikander. I am having 14+ years of experience in software development and I have done similar kind of jobs in past I am ready to start this job. I will provide you best services in development. Regardig this Job: I wil do a C# Console application which willl do all stuff which is mentioned. It will read / write/ send mail / insert records etc. We will there after attach this to sql server agent job which we can configure as we need job to run. Hope you will like idea and allow me to work on this project. Code will be fully documented. I am working in Microsoft technologies and you can find the details below. I have started my own venture and very much willing to place a mark here. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty, hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander

I will create SSIS package for you. I have read the details and willing to do work with you. Feel free to contact me for further discussion. Regards, Moeen Ahmed

Hello As per your post ,I have understood your requirement. We are a team of 25 providing expertise software solutions extensively with .Net development. For more details about us you may like to visit our website http://www.moreyeahs.com. Below is list of Areas we work in • Angular JS 2.0 • Node.js • Full Microsoft Stack , C# ,SSRS, SSIS , .Net MVC • Hybrid Mobile App using IONIC and PhoneGAP • PHP About Me: I have worked as a Solution Architect in multiple fortune 500 Companies in the US. I recently moved from US to India to do my own startup. Since I was on the other side of the court while I was working in the US,which I did for 10 years I really understand the issues and pain points which most of the companies face while dealing with offshore. We look forward to a mutually beneficial association. Thank you

I am Krunal K. Doshi from INDIA having 12+ year of experience in IT field having completed majority of projects with Microsoft Technologies. I have a team of experience programmers expertise in .NET(MVC and traditional Web Forms), Open Source Technologies (PHP, MySQL, WordPress, Magento, WooCommerce, Laravel Framework), Android, iOS etc.. I have gone through your requirements and understood it; I'm confident we can do a great job for you however this will be our first project with SSIS hence budget is low too. We have done a similar project in past, but sort of offline version where it is managed by Task Scheduler. We believe in establishing long term relationship with our clients, giving them best services at a reasonable rate. Looking forward to an opportunity to discuss this project with you and work on it.

I am interested..

Dear friend, I have good experience in building SSIS packages that performs automated tasks in the sql server. I have implemented and a number of ETL projects for my clients and it will be easy go for me. I have a suggestion that can greatly improve the performance of insert operation by adapting BCP. Please ping me if there is anything you would like to discuss with me further on this. Thanks, Hemant.

I done this package using ssis with excel

I'm free to do this tonight. I have developed SSIS/MSSQL/.NET packages since their inception. This is about a $2000 project but I will do it for $500 if we can do it in a straight-forward manner and tonight. I'm in NY. Regards, Joe

I am a Microsoft Data Platform MVP and work on building solutions day in and day out. I am confident that I will be the best resource for your project.

Hi My name is John and I have been developing SSIS since SQL 2000 (when it was still called DTS). My experience with SSIS included - Import/Export data from/to file or database. - Data conversion - Use script component for data integration (import/export). - Email with attachment Please let me know details about the project, and I can start right away. (Please note that I am only available during central timezone night hours as I am doing this as a freelance on the side). Thank you for your patience for taking the time to read my proposal, Sincerely yours, John

I have my mcse in data platform. I do these type of ssis packages every day.

Hi, I'm a SQL Server specialist based in London, and I'd be delighted to complete this piece of work for you. I've been working with SQL Server for 15 years now, and I predominantly work for the large UK banks here in London. Thanks, Peter Schofield

I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 and 2012. The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL. For performance reasons the KPIS are replicated to another DB which exploits the reports via SSRS to the consumers. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Finally several other reports are daily automatically produced and sent via email to the recipients. The size of the Master DB, which I am the Admin, is about 4TB and the replicated KPI DB is 350GB

As a senior software engineer already worked for for some big projects using .NET technology I'd like to contribute to your project. Please call me if you prefer to get more discussion. I did some SSIS packages supporting to export data and insert to database for a big project need to integrate with others.

Having enough experience to do this as I recently completed the same for others