Find Jobs
Hire Freelancers

SSIS dynamic columns (reading from MS Excel into SQL Table)

$10-30 USD

Closed
Posted about 8 years ago

$10-30 USD

Paid on delivery
Hi All, Requirement is to read the data from Excel file using SSIS dynamically and insert into a dynamic table. Columns in the excel sheet are not static. It may have 2 columns today and 6 columns tomorrow never know. I suppose SQL server table has to be dynamic as well. . Column names in SQL Server table should have the same names as of Excel columns. This is urgent and need some one who has good expertise in SSIS . Please dont use openrowset as my system is not compatible with 32 bit applications.
Project ID: 9938536

About the project

13 proposals
Remote project
Active 8 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
13 freelancers are bidding on average $47 USD for this job
User Avatar
Hello, I am very much interested to do this work. I have a question: do you want to import the data to the same dynamic table always or always into a new table? Looking forward to have a positive response from you. Thanks
$28 USD in 1 day
5.0 (114 reviews)
6.3
6.3
User Avatar
I can do it. can start now.
$100 USD in 3 days
5.0 (34 reviews)
4.9
4.9
User Avatar
Hi, I have good experience on SSIS and done lots of ETL projects. I did the similar task before so I know better way to do this job. If you like to work with me, then leave a message.... Thanks
$111 USD in 2 days
4.9 (2 reviews)
4.5
4.5
User Avatar
I am an experienced DBA and SQL Developer. I can help you to build the SSIS package meeting your requirements.
$25 USD in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done lot of data migration during my many ERP implemenations using SSIS Packages. Experience Summary • Microsoft Dynamics CRM Developer with over 7+ years of experience in MS CRM implementation and customization. Thorough with designing and supporting business processes with focus in sales, marketing and customer service. • Strong background in designing and deploying integrated and custom solutions. Worked on multiple Microsoft technologies with the likes of ASP .NET, C#, ASP. NET MVC, WCF, MS SQL Server 2005/2008, SSIS, SSRS. • Sound technical knowledge of Microsoft Dynamics CRM platform which includes workflow, plugins, views, entity model, security, web services. • Possess extensive knowledge of the Agile and SDLC processes and has managed projects following both the methodologies. I adept at all phases of project development from concept through realization. • I have hands on experience in designing Service Oriented Applications (SOA), 3-tier Applications, HTML5 and MVC based web applications. Work Experience • Currently working with MultiChoice, South Africa as MS CRM Technical Consultant • Worked as Design Lead in Nihilent technology [Mar 2014 to Jan 2015] • Worked as System Analyst in MultiChoice, South Africa [Onsite] [Dec 2011 to Feb 2014] • Worked as Software Developer in Nihilent Technologies [Jan 2010 to Nov 2011] • Worked as Software Developer in Mimansa Software Systems Pvt Ltd [Dec 2008 to Dec 2009]
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can able to work for you. Please let me know if I can start the work. I am interested to work with you. Thanks
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm expert in SSiS and I'm able to do this job for you . please do let me know when you want me to start work. Thanks, Hafiz
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have developed a number of SSIS package in my organization. I think I can do this properly and with very less price. I just need a kick start in freelancing.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear, I have 4+ years of hands on, end-to-end database commercial experience and strong knowledge about SSIS / SQL programming and data warehouse. Pleae contact me, we can do this project together. Best regards, Piotr Pawełczak
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, currently I am working as SQL DBA. Total experience is 5 yrs. Please find my below task details. Created SSIS package to transfer data from SQL to ORACLE. Created SSIS package for loading & exporting data to file (ETL). Worked on query optimization & developed stored procedures, triggers, functions based on requirement in both SQL & ORACLE. Working on database migration from SQL to ORACLE.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working as senior Microsoft BI Developer with one of the top IT Consulting company with industry standard skill set and experience as below : Expertise in Data warehouse modelling with very sound fundamental concepts of DWH. Extensive hands on practice in SSIS package creations using Data connections like: ADO .NET/ Excel/ Flat File Source/OLE DB/XML, Data flow Transformations like: Aggregate/Sort/Merge/Merge Join/UNION ALL/PIVOT/Script Component/Derived Column/Conditional Split/Multicast, Control Flows like: Expressions/Precedence Constraints/Sequence Containers/Variables. Expertise in writing effective T-SQL Code/Triggers/Views/Stored Procedures/ Functions/Query optimization and tuning/Indexing using SQL Server 2008 & 2012. Practical working experience on Microsoft SQL Server Parallel Data Warehouse (PDW) and data warehousing concepts. Very Good experience in developing dashboards for senior leadership using SSRS, PowerView & PowerPivot for developing Tabular/Matrix/Chart reports. I would be an ideal match for the skill set that you are looking for and creating end to end BI solution. I would love to talk to you about how I can be of great help to you. Thank you very much -- look forward to your positive response.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
devon, United States
4.9
3
Payment method verified
Member since Jul 26, 2014

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.