Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get SSIS Package that read dynamic columns of CSV and load in SQL Table

Ajeet Y.Status: Offline
Ajeet Y.
Preview image

Let a pro handle the details

Buy Database Queries services from Ajeet, priced and ready to go.
Ajeet Y.Status: Offline
Ajeet Y.
Preview image

Let a pro handle the details

Buy Database Queries services from Ajeet, priced and ready to go.

Project details

This is an ETL Project (SSIS Package) which used to read the CSV file. CSV files which have number of columns are dynamic.

For example:- If you are getting data of an item yearly and value of each year in a separate column. This package will help you to automatic read the column value and add the year column in table automatic.
Database Type
MS SQL
What's included
Service Tiers Starter
$29
Standard
$30
Advanced
$31
Delivery Time 1 day 1 day 1 day
Number of Revisions
333
Number of Queries
555
Query Debugging
Query Optimization
Query Scheduling
Query Analysis
-
-
-
Source Code
Ajeet Y.Status: Offline

About Ajeet

Ajeet Y.Status: Offline
MSSQL Database and ETL Developer
Jaipur, India - 9:48 am local time
10 year’s work experience as MS SQL Server Developer and ETL (SSIS Package) in various domain (Energy Benchmarking, Portfolio Management, Travel Domain and Indexing) Project’s.

Written SQL queries for DDL, DML, DCL and TCL Commands.

Develop tables, views, stored procedures, triggers, indexes and constraints.

Knowledge of working with JSON and XML in SQL.

Create queries on large data sets.

Experience in highly mathematical formula creations and calculations.

Comfortable in Joins, Sub – Queries and Grouping.

Analyzing of SQL queries to improve the performance and minimizing the execution.

Provide TSQL support in critical production issue resolution.

Maintenance of Complex databases in SQL Server 2008R2, 2012 and 2014.

Knowledge of Asp.Net C#.

Modify and maintain existing applications based on needs of the business.

Knowledge of all phases of the Software Development Life Cycle including Requirement Analysis, Design & Construction, Testing, UAT & Production.

Steps for completing your project

After purchasing the project, send requirements so Ajeet can start the project.

Delivery time starts when Ajeet receives requirements from you.

Ajeet works on your project following the steps below.

Revisions may occur after the delivery date.

Add Package in Visual Studio SSIS project

Add this package in SSIS Project and after that configure the variables value as per your requirements

Review the work, release payment, and leave feedback to Ajeet.