create a how-to guide for SSIS

Cancelled Posted 5 years ago Paid on delivery
Cancelled Paid on delivery

Create a how to guide for SSIS ,using AdventureWorks database and SQL server 2014,showing the following:

(1) How to create a ETL mapping.

(2) How to replace a flat file source with an ODBC source.

(3) How to transfer ETL code from SSIS catalog database to TFS and from file system to TFS and from TFS to SSIS catalog

(4) How to use a parameter for source and target connection.

(5) How to move ETL mapping code from one SSIS catalog to another SSIS catalog one mapping at a time, one project at a time, one folder at a time

(6) What you need to know before creating a SCD2 ETL mapping(at least 3 points)

(7) Create a list of debugging techniques(at least 3 techniques)

(8) Self documenting techniques for ETL code(at least 3 techniques)

The how to guide needs to have steps in text and screenshots and need to be provided in ms-word format.

Data Warehousing Database Administration Microsoft SQL Server SSIS (SQL Server Integration Services)

Project ID: #17095279

About the project

9 proposals Remote project Active 5 years ago

Awarded to:

SergioAlfaroV

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data wareh More

$200 USD in 5 days
(8 Reviews)
4.4

9 freelancers are bidding on average $222 for this job

jagdishbhatt38

I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql),SSIS,SSRS. I can provide you better solutio More

$400 USD in 8 days
(21 Reviews)
4.8
sreenivas2903

Hi i will guide in this and explain what happens in realtime and let you know the concepts but tell me do you tfs versioning tool ?

$166 USD in 3 days
(8 Reviews)
3.6
Dreamerweaver

Hi, In 1 day 6 hr I can help ur team learn siss

$111 USD in 1 day
(0 Reviews)
0.0
ayoubasnaoui

Hello sir, With an experience of 5 years as technical leader in Microsoft Business Intelligence suite, i can be a valuable asset for you in that work. If you're interested we can get in touch and talk more over a More

$88 USD in 4 days
(0 Reviews)
0.0
nikhilkapale87

I have 6 years of experience in Data warehousing. Quality of code would be best with comments and annotations so any one can understand it who is a beginner or non technical. It makes it easy to support the jobs to More

$88 USD in 7 days
(0 Reviews)
0.0