LEARN IN JUST MSBI MSBI MSBI ONE MONTH BY INDUSTRY EXPERTS IN INDIA

Learn in just MSBI MSBI MSBI One month by Industry experts in Elegant it 1 IntroductiontoIntegrationServices Defining SQLServerIntegrationServices Exploring the needformigrating diverse data Therole ofbusinessintelligence(BI) 2 SSISArchitectureandTools Managing heterogeneousdata •Leveraging theExtract, TransformandLoad(ETL)capabilities ofSSIS •Running wizardsforbasicmigrations •Creating packagesfor complextasks Illustrating SSISarchitecture • Distinguishingbetweendataflow pipelineandpackageruntime •Executing packages on theclientside orhosted in theSSISservice Upgrading legacy DTS •Executing existing DTSpackagesin theSSISenvironment •Converting DTS packagestoSSISwiththemigrationwizard •Logging migrationresults Implementing TasksandContainers Utilizing basicSSISobjects •Configuring connectionmanagers •Adding dataflowtaskstopackages •Reviewing progresswithdataviewers •Assembling taskstoperformcomplex datamigrations Operating system level tasks •Copying,moving anddeleting files •Transferring fileswith theFTPtask •Reading system informationwithWMI querylanguage(WQL) Communicating withexternal sources •Sending messagesthroughmail • Detecting system eventswithWMI Processing XML •Iterating XMLnodes •Writing XMLfilesfrom databases 4 Transforming with theDataFlowTask Performing transformsoncolumns •Converting and calculating columns •Transforming withCharacter Map Combining andsplitting data •Profiling data •Merge,Union,Conditional Split •Multicasting and converting data Manipulating rowsetsandBLOBdata •Aggregate,sort,auditandlook updata •Importing andexporting BLOBdata •Redirecting errorrows Performing database operations •Implementing Change DataCapture(CDC) •Executing aSQLtask •Bulkinserting datafromtextfiles 5 ErrorHandling,LoggingandTransactions Organizing packageworkflow • Defining success,failure,completionandexpressionprecedenceconstraints •Handling eventsandeventbubbling Designing robustpackages •Choosing log providers •Adapting solutionswithpackageconfigurations •Auditing packageexecutionresults 6 AdministeringBusinessIntelligence Managing andsecuring packages •Storing packagesinPackageStoreandmsdb •Encrypting packageswithpasswordsanduserkeys Integrating withotherBI components • Displaying datainReporting Services •Accessing package datawithADO.NET Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore -