create a how-to guide for SSIS

已取消 已发布的 5 年前 货到付款
已取消 货到付款

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.

数据仓库 数据库管理 微软 SQL 服务器 SSIS (SQL Server Integration Services)

项目ID: #17095279

关于项目

9个方案 远程项目 活跃的5 年前

授予:

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 更多

$200 USD 在5天内
(8条评论)
4.4

有9名威客正在参与此工作的竞标,均价$222/小时

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 更多

$400 USD 在8天内
(21条评论)
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 在3天内
(8条评论)
3.6
Dreamerweaver

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

$111USD 在1天里
(0条评论)
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 更多

$88 USD 在4天内
(0条评论)
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 更多

$88 USD 在7天内
(0条评论)
0.0