create a how-to guide for SSIS
$30-250 USD
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.
Project ID: #17095279
About the project
Awarded to:
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
9 freelancers are bidding on average $222 for this job
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
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 ?
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
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