MSBI Tutor

Step 1: Click on windows button and select import and export wizard Step 2: Select data source Select source database Step 3: Select destination server as shown in bellow Select destination database as shown in bellow Step 4: Specify table copy or query Step 5: Select tables to copy to destination database Click on next Step 6: Save and run package page looks like bellow Select save SSIS package as shown in bellow Change package save location to file system Click on next Change package name and  location Click on next And click on finish to complete task Step 7: Package created in destination folder.

Step 1: Drag and drop Data flow task to control flow tab and edit Step 2: Take excel data source Create new excel connection Browse source file from local syatem Select sheet name Click preview and see few null values in TaxAmt column Step 3: Drag and drop derived column and replace TaxAmt column Method 1: Syntax for expression is ISNULL(TaxAmt) ? 0 : TaxAmt Method 2: REPLACENULL(TaxAmt,0) Step 4: Execute task

Step 1: My excel template looks like bellow and want to load into this template  Step 2: My input data like bellow Step 3: Drag and drop data flow task to control flow tab Step 4: Edit data flow task and drag & drop OLEDB source as shown in bellow Edit source Provide server and data base name Select data access mode as SQL command and provide SQL query Click on preview data Step 5: Drag and drop excel destination Click on new connection manager Browse template from system And select sheet name from excel sheets Map source with destination columns  Step 6: Some columns having data conversion issue as shown in bellow Drag and drop data conversion transformation Change data type of Region column as shown in bellow And map with new region column Step 7: Execute task After execution i got task validation issue as shown in bellow Rectifying task validation error, have change ValidateExtrnalMetadata of destination to False Execute again Data was loaded to my report template as s...