01. Course Overview\01. Course Overview.mp4 |
3,896,365 |
809F8EF3 |
01. Course Overview\01. Course Overview.srt |
2,366 |
817FC17E |
02. Introduction\01. Introducing the Course.mp4 |
7,757,583 |
5CCC8095 |
02. Introduction\01. Introducing the Course.srt |
8,312 |
D34DD882 |
02. Introduction\02. Understanding the Demo Project.mp4 |
22,355,295 |
C198C91E |
02. Introduction\02. Understanding the Demo Project.srt |
7,384 |
23F84604 |
03. Creating and Managing the Catalog\01. Creating and Managing the Catalog.mp4 |
18,591,047 |
413B07C3 |
03. Creating and Managing the Catalog\01. Creating and Managing the Catalog.srt |
11,792 |
703AD58E |
04. Deploying to the Catalog\01. Deploying to the Catalog.mp4 |
22,688,800 |
AF19BEFF |
04. Deploying to the Catalog\01. Deploying to the Catalog.srt |
9,603 |
A1FA4549 |
04. Deploying to the Catalog\02. Executing Packages from the Catalog.mp4 |
14,420,629 |
CBBACA94 |
04. Deploying to the Catalog\02. Executing Packages from the Catalog.srt |
6,061 |
04613C4F |
05. Using Canned Dashboard Reports\01. Executing the Reports and Understanding the Overview Report.mp4 |
19,815,484 |
3A9B48DE |
05. Using Canned Dashboard Reports\01. Executing the Reports and Understanding the Overview Report.srt |
9,808 |
D1B72951 |
05. Using Canned Dashboard Reports\02. Reviewing the Messages and Performance Reports.mp4 |
13,850,199 |
E89A5C65 |
05. Using Canned Dashboard Reports\02. Reviewing the Messages and Performance Reports.srt |
5,784 |
F11B6733 |
05. Using Canned Dashboard Reports\03. Running the Server Level Reports.mp4 |
11,789,942 |
D310AC04 |
05. Using Canned Dashboard Reports\03. Running the Server Level Reports.srt |
5,827 |
A6570496 |
06. Implementing Parallelism for Faster Loading in SSIS\01. Understanding the Master Package and Controlling Package Flow.mp4 |
25,072,275 |
7D5B3F6D |
06. Implementing Parallelism for Faster Loading in SSIS\01. Understanding the Master Package and Controlling Package Flow.srt |
10,599 |
B8368994 |
06. Implementing Parallelism for Faster Loading in SSIS\02. Reviewing the Required Control Flow Components.mp4 |
18,301,003 |
F550028A |
06. Implementing Parallelism for Faster Loading in SSIS\02. Reviewing the Required Control Flow Components.srt |
7,827 |
0D70167C |
07. Configuring a Project or Package\01. Configuring a Project or Package.mp4 |
21,125,258 |
14B852AD |
07. Configuring a Project or Package\01. Configuring a Project or Package.srt |
10,645 |
A5C8B400 |
08. Managing Variables and Connection Strings through Environments\01. Setting up and Mapping Packages to Environments.mp4 |
14,083,850 |
37EBCCA0 |
08. Managing Variables and Connection Strings through Environments\01. Setting up and Mapping Packages to Environments.srt |
9,216 |
0247DA4C |
08. Managing Variables and Connection Strings through Environments\02. Running Packages Using Environments.mp4 |
20,701,617 |
EB9BE499 |
08. Managing Variables and Connection Strings through Environments\02. Running Packages Using Environments.srt |
8,635 |
6B5E1881 |
09. Using the Catalog for Logging\01. Understanding the Basic Logging Level.mp4 |
14,391,016 |
AADFF0AA |
09. Using the Catalog for Logging\01. Understanding the Basic Logging Level.srt |
5,360 |
F1F395AD |
09. Using the Catalog for Logging\02. Examining Performance and Verbose Level Logging.mp4 |
13,278,425 |
F17FC272 |
09. Using the Catalog for Logging\02. Examining Performance and Verbose Level Logging.srt |
5,025 |
B737C1F1 |
09. Using the Catalog for Logging\03. Learning About Runtime Lineage and Other Logging Levels.mp4 |
9,988,239 |
7128126D |
09. Using the Catalog for Logging\03. Learning About Runtime Lineage and Other Logging Levels.srt |
4,304 |
C8A4780A |
09. Using the Catalog for Logging\04. An Overview of the Catalog Views.mp4 |
9,292,345 |
60A438CE |
09. Using the Catalog for Logging\04. An Overview of the Catalog Views.srt |
4,753 |
063239DD |
09. Using the Catalog for Logging\05. Sample Queries. List All Packages.mp4 |
13,151,666 |
7F830862 |
09. Using the Catalog for Logging\05. Sample Queries. List All Packages.srt |
4,653 |
363A7CBB |
09. Using the Catalog for Logging\06. Sample Queries. Get Package Executions, Runtimes.mp4 |
14,516,600 |
78DB56D4 |
09. Using the Catalog for Logging\06. Sample Queries. Get Package Executions, Runtimes.srt |
5,200 |
32C27F12 |
09. Using the Catalog for Logging\07. Sample Queries. Top 5 Runtimes, Listing Executables, Last 5 Executions.mp4 |
15,729,925 |
A2F1EB72 |
09. Using the Catalog for Logging\07. Sample Queries. Top 5 Runtimes, Listing Executables, Last 5 Executions.srt |
5,197 |
F2F8559A |
09. Using the Catalog for Logging\08. Sample Queries. Log Messages, Executive Dashboard.mp4 |
16,255,019 |
BEA15F5E |
09. Using the Catalog for Logging\08. Sample Queries. Log Messages, Executive Dashboard.srt |
6,841 |
623338D7 |
10. Developing Custom Logging\01. Understanding the Logging Table.mp4 |
10,375,224 |
F0BDDB33 |
10. Developing Custom Logging\01. Understanding the Logging Table.srt |
4,323 |
C1811474 |
10. Developing Custom Logging\02. Control Flow Tasks for Custom Logging.mp4 |
24,702,827 |
86993F3E |
10. Developing Custom Logging\02. Control Flow Tasks for Custom Logging.srt |
11,800 |
6821643D |
10. Developing Custom Logging\03. Querying the Logging Data with Custom Views.mp4 |
22,511,541 |
43280DBD |
10. Developing Custom Logging\03. Querying the Logging Data with Custom Views.srt |
8,560 |
A620D5A5 |
11. Creating an SSIS Package Template for Re-use\01. Creating a Template Package.mp4 |
13,510,148 |
E4E09762 |
11. Creating an SSIS Package Template for Re-use\01. Creating a Template Package.srt |
4,652 |
076E7FBC |
11. Creating an SSIS Package Template for Re-use\02. Deploying the Template.mp4 |
14,779,752 |
684505AB |
11. Creating an SSIS Package Template for Re-use\02. Deploying the Template.srt |
6,353 |
222ACFB0 |
11. Creating an SSIS Package Template for Re-use\03. Creating a Package from a Template.mp4 |
13,912,279 |
01B09879 |
11. Creating an SSIS Package Template for Re-use\03. Creating a Package from a Template.srt |
7,295 |
D6A1D3ED |
12. Creating Reusable Units of an SSIS Package Workflow\01. Creating and Using a Package Part.mp4 |
21,094,483 |
AFAE994F |
12. Creating Reusable Units of an SSIS Package Workflow\01. Creating and Using a Package Part.srt |
7,916 |
6CC91786 |
12. Creating Reusable Units of an SSIS Package Workflow\02. Advanced Package Parts.mp4 |
15,156,000 |
4A1D05B9 |
12. Creating Reusable Units of an SSIS Package Workflow\02. Advanced Package Parts.srt |
6,273 |
FC85E61C |
13. Summary\01. Summary.mp4 |
3,481,486 |
8D465345 |
13. Summary\01. Summary.srt |
3,699 |
CD5A88F0 |
Exercise Files\02\introduction-slides.pdf |
441,711 |
F4BFD76A |
Exercise Files\03\creating-and-managing-the-catalog-slides.pdf |
116,025 |
0154C7B7 |
Exercise Files\04\deploying-to-the-catalog-slides.pdf |
114,218 |
98382959 |
Exercise Files\05\using-canned-dashboard-reports-slides.pdf |
115,723 |
19F7E59E |
Exercise Files\06\implementing-parallelism-for-faster-loading-in-ssis-slides.pdf |
123,306 |
C24DB195 |
Exercise Files\07\configuring-a-project-or-package-slides.pdf |
131,538 |
C72BE00F |
Exercise Files\08\managing-variables-and-connection-strings-through-environments-slides.pdf |
141,912 |
6C5490DA |
Exercise Files\09\using-the-catalog-for-logging-slides.pdf |
235,315 |
2A38B553 |
Exercise Files\10\developing-custom-logging-slides.pdf |
126,115 |
7687CEE4 |
Exercise Files\11\creating-an-ssis-package-template-for-re-use-slides.pdf |
150,265 |
86EE8EB7 |
Exercise Files\12\creating-reusable-units-of-an-ssis-package-workflow-slides.pdf |
157,866 |
0412A2C2 |
Exercise Files\13\summary-slides.pdf |
197,173 |
9B6285D0 |
Exercise Files\course assets\Demo_SSIS\City.dtsx |
72,178 |
80D11966 |
Exercise Files\course assets\Demo_SSIS\Demo_SSIS.database |
1,695 |
BFE394C1 |
Exercise Files\course assets\Demo_SSIS\Demo_SSIS.dtproj |
42,533 |
3A894C89 |
Exercise Files\course assets\Demo_SSIS\Demo_SSIS.dtproj.user |
952 |
EE3B49F2 |
Exercise Files\course assets\Demo_SSIS\Employee.dtsx |
36,942 |
BB8ACC53 |
Exercise Files\course assets\Demo_SSIS\EmployeePP.dtsx |
65,469 |
31A0AEA3 |
Exercise Files\course assets\Demo_SSIS\EmployeePP.dtsx.designer |
56,543 |
FCCE8134 |
Exercise Files\course assets\Demo_SSIS\EmployeeV2.dtsx |
60,445 |
3D753CC4 |
Exercise Files\course assets\Demo_SSIS\InsertExecutionBegan.dtsxp |
7,027 |
CA0256A5 |
Exercise Files\course assets\Demo_SSIS\InsertExecutionEnded.dtsxp |
13,517 |
E1BA2289 |
Exercise Files\course assets\Demo_SSIS\Master.dtsx |
68,066 |
034B7C4B |
Exercise Files\course assets\Demo_SSIS\obj\Development\BuildLog.xml |
2,539 |
EDBEDD8B |
Exercise Files\course assets\Demo_SSIS\obj\Development\City.dtsx |
72,175 |
523EEB2B |
Exercise Files\course assets\Demo_SSIS\obj\Development\Demo_SSIS.dtproj |
42,408 |
4A7FFD9B |
Exercise Files\course assets\Demo_SSIS\obj\Development\Employee.dtsx |
36,939 |
EF36EC70 |
Exercise Files\course assets\Demo_SSIS\obj\Development\EmployeePP.dtsx |
66,005 |
303B037E |
Exercise Files\course assets\Demo_SSIS\obj\Development\EmployeeV2.dtsx |
60,442 |
DB397D10 |
Exercise Files\course assets\Demo_SSIS\obj\Development\Master.dtsx |
68,063 |
D7FD07FF |
Exercise Files\course assets\Demo_SSIS\obj\Development\PackageRunnerPlaceHolder.dtsx |
2,354 |
AED7F631 |
Exercise Files\course assets\Demo_SSIS\obj\Development\PaymentMethod.dtsx |
57,182 |
FBE36C84 |
Exercise Files\course assets\Demo_SSIS\obj\Development\Project.params |
837 |
F5363F4D |
Exercise Files\course assets\Demo_SSIS\obj\Development\SourceDB.conmgr |
454 |
C28BE609 |
Exercise Files\course assets\Demo_SSIS\obj\Development\TargetDB.conmgr |
462 |
9695AADF |
Exercise Files\course assets\Demo_SSIS\obj\Development\Template.dtsx |
28,663 |
2B8C173D |
Exercise Files\course assets\Demo_SSIS\obj\Development\TransactionType.dtsx |
57,574 |
DACA02EB |
Exercise Files\course assets\Demo_SSIS\PackageRunnerPlaceHolder.dtsx |
2,357 |
AE7D9749 |
Exercise Files\course assets\Demo_SSIS\PaymentMethod.dtsx |
57,185 |
FAC0B86E |
Exercise Files\course assets\Demo_SSIS\Project.params |
840 |
E6AA3C98 |
Exercise Files\course assets\Demo_SSIS\ReadMe.md |
1,906 |
F0B8E421 |
Exercise Files\course assets\Demo_SSIS\SourceDB.conmgr |
457 |
FAB24371 |
Exercise Files\course assets\Demo_SSIS\TargetDB.conmgr |
465 |
4E977911 |
Exercise Files\course assets\Demo_SSIS\Template.dtsx |
28,666 |
6840BCB9 |
Exercise Files\course assets\Demo_SSIS\TransactionType.dtsx |
57,577 |
3D6C8C2B |
Exercise Files\course assets\Documentation\AboutMe.md |
6,822 |
97BC2557 |
Exercise Files\course assets\Documentation\CourseOutline.md |
6,779 |
94EAD58A |
Exercise Files\course assets\Documentation\DemoSteps.md |
1,839 |
2DB82935 |
Exercise Files\course assets\Documentation\DemoSteps_M02_Introduction.md |
552 |
8D0A8A0A |
Exercise Files\course assets\Documentation\DemoSteps_M03_Creating_and_Managing_The_Catalog.md |
3,637 |
AC27C1D8 |
Exercise Files\course assets\Documentation\DemoSteps_M04_Deploying_to_the_Catalog.md |
2,195 |
68809A27 |
Exercise Files\course assets\Documentation\DemoSteps_M05_Using_Canned_Dashboard_Reports.md |
2,189 |
BE4ABD17 |
Exercise Files\course assets\Documentation\DemoSteps_M06_Implementing_Parallelism_for_Faster_Loading_in_SSIS.md |
3,962 |
E181EAF9 |
Exercise Files\course assets\Documentation\DemoSteps_M07_Configuring_a_Project_or_Package.md |
3,130 |
A664C4F6 |
Exercise Files\course assets\Documentation\DemoSteps_M08_Managing_Variables_and_Connection_Strings_through_Environments.md |
5,019 |
86BABCB9 |
Exercise Files\course assets\Documentation\DemoSteps_M09_Using_the_Catalog_for_Logging.md |
7,637 |
D744C7A3 |
Exercise Files\course assets\Documentation\DemoSteps_M10_Developing_Custom_Logging.md |
8,304 |
051A27BF |
Exercise Files\course assets\Documentation\DemoSteps_M11_Creating_an_SSIS_Package_Template_for_Reuse.md |
1,910 |
086147AF |
Exercise Files\course assets\Documentation\DemoSteps_M12_Creating_Reusable_Units_of_an_SSIS_Package_Workflow.md |
4,507 |
FBF23C0C |
Exercise Files\course assets\Documentation\DemoSteps_M13_Summary.md |
166 |
FD98F5F9 |
Exercise Files\course assets\Documentation\Documentation.projitems |
2,147 |
36E94563 |
Exercise Files\course assets\Documentation\Documentation.shproj |
1,051 |
1F9D8877 |
Exercise Files\course assets\Documentation\MarkdownCheatSheet.md |
8,710 |
83FD39AC |
Exercise Files\course assets\Documentation\ReadMe.md |
1,457 |
B61B582A |
Exercise Files\course assets\Documentation\ToolsRequired.md |
1,338 |
339A5E32 |
Exercise Files\course assets\Managing_SSIS_Projects.sln |
4,041 |
A2C26F03 |
Exercise Files\course assets\Monitoring_SSIS_Projects\Executive_Dashboard.sql |
3,797 |
453914CB |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_Last_5_Packages_Executed.sql |
5,776 |
3BC23108 |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_List_of_Executed_Tasks.sql |
2,581 |
C39E0A71 |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_List_of_Package_Executions_Start_and_End_Times.sql |
2,659 |
D9107577 |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_Messages_Generated_During_Package_Execution.sql |
1,819 |
885E41EC |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_Numer_Of_Package_Executions_And_Average_Run_Time.sql |
2,267 |
B7BFD14E |
Exercise Files\course assets\Monitoring_SSIS_Projects\Get_Top_5_Longest_Running_Packages.sql |
3,972 |
57060F08 |
Exercise Files\course assets\Monitoring_SSIS_Projects\List_All_Packages_In_The_Catalog.sql |
2,023 |
B170485E |
Exercise Files\course assets\Monitoring_SSIS_Projects\Monitoring_SSIS_Projects.projitems |
1,332 |
1DE6CF6F |
Exercise Files\course assets\Monitoring_SSIS_Projects\Monitoring_SSIS_Projects.shproj |
1,062 |
28846976 |
Exercise Files\course assets\Monitoring_SSIS_Projects\ReadMe.md |
1,103 |
8395E596 |
Exercise Files\course assets\ReadMe.md |
922 |
DECB8EB4 |
Exercise Files\course assets\SourceDB\Application\Tables\Cities.sql |
3,413 |
DE16D79D |
Exercise Files\course assets\SourceDB\Application\Tables\Countries.sql |
5,249 |
26D46454 |
Exercise Files\course assets\SourceDB\Application\Tables\Countries_Archive.sql |
1,039 |
1F1D57E5 |
Exercise Files\course assets\SourceDB\Application\Tables\PaymentMethods.sql |
2,120 |
D6405DFA |
Exercise Files\course assets\SourceDB\Application\Tables\PaymentMethods_Archive.sql |
500 |
768CB2DB |
Exercise Files\course assets\SourceDB\Application\Tables\People.sql |
9,321 |
AC6BD3FA |
Exercise Files\course assets\SourceDB\Application\Tables\People_Archive.sql |
1,371 |
7B649D83 |
Exercise Files\course assets\SourceDB\Application\Tables\StateProvinces.sql |
4,945 |
40B41863 |
Exercise Files\course assets\SourceDB\Application\Tables\StateProvinces_Archive.sql |
826 |
C8CCF3F5 |
Exercise Files\course assets\SourceDB\Application\Tables\TransactionTypes.sql |
2,148 |
02EAB631 |
Exercise Files\course assets\SourceDB\Application\Tables\TransactionTypes_Archive.sql |
495 |
208D499D |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Functions\GetCityLocation.sql |
432 |
0EBAEA56 |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Functions\GetStateProvinceID.sql |
556 |
CAD097CE |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Stored Procedures\DeactivateTemporalTablesBeforeDataLoad.sql |
50,308 |
A97AC547 |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Stored Procedures\ReactivateTemporalTablesAfterDataLoad.sql |
6,209 |
CBC95E17 |
Exercise Files\course assets\SourceDB\Integration\Stored Procedures\GetCityUpdates.sql |
7,211 |
2CE0D417 |
Exercise Files\course assets\SourceDB\Integration\Stored Procedures\GetPaymentMethodUpdates.sql |
2,810 |
8DBC31F6 |
Exercise Files\course assets\SourceDB\Integration\Stored Procedures\GetTransactionTypeUpdates.sql |
2,830 |
074A8256 |
Exercise Files\course assets\SourceDB\Integration\Tables\CityChanges.sql |
712 |
6FAF448B |
Exercise Files\course assets\SourceDB\Integration\Tables\PaymentMethodUpdates.sql |
253 |
50AC5E2C |
Exercise Files\course assets\SourceDB\Integration\Tables\TransactionTypeUpdates.sql |
228 |
36F7D709 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds100-ins-app-people.sql |
15,522 |
16B8F706 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds110-ins-app-countries.sql |
2,968,086 |
924F7D98 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds130-ins-app-paymentmethods.sql |
482 |
72549B28 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds140-ins-app-stateprovinces.sql |
6,024 |
6FE3AD68 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds142-upd-app-stateprovinces-borders.sql |
568,744 |
C5787856 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-a.sql |
249,502 |
9C179132 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-b.sql |
483,093 |
C8B4C5AD |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-c.sql |
540,651 |
D6F81673 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-d.sql |
196,213 |
55393B05 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-e.sql |
205,540 |
112E0C64 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-f.sql |
215,293 |
A2430B82 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-g.sql |
264,666 |
A1D68EF3 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-h.sql |
322,828 |
BCD9CBD1 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-i.sql |
51,105 |
D908240A |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-j.sql |
62,587 |
7D41A5B2 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-k.sql |
114,071 |
14B62C32 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-l.sql |
371,066 |
13F4EB1A |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-m.sql |
501,417 |
30BF92F5 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-n.sql |
214,366 |
DEB09A2C |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-o.sql |
145,706 |
0948BE61 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-p.sql |
347,961 |
EF757D2F |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-q.sql |
101 |
4E59EAA6 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-r.sql |
269,252 |
865F1147 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-s.sql |
575,524 |
4729FFD6 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-t.sql |
187,438 |
6B88A5BB |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-u.sql |
23,057 |
AB60B407 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-v.sql |
73,892 |
2D72C39A |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-w.sql |
387,409 |
9ABC03CA |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-x.sql |
89 |
0D94E1CB |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-y.sql |
9,043 |
95F277B4 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities-z.sql |
90 |
7160682D |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds150-ins-app-cities.sql |
394,186 |
96AE9ADC |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds151-ins-post-app-cities.sql |
496 |
5ED74A5D |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\pds160-ins-app-transactiontypes.sql |
1,021 |
707AFAD7 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts\Script.PostDeployment1.sql |
2,227 |
C0213135 |
Exercise Files\course assets\SourceDB\Security\Application.sql |
343 |
53370C07 |
Exercise Files\course assets\SourceDB\Security\DataLoadSimulation.sql |
304 |
7F2868DA |
Exercise Files\course assets\SourceDB\Security\Integration.sql |
283 |
897885BD |
Exercise Files\course assets\SourceDB\Security\Sequences.sql |
267 |
AA3FC970 |
Exercise Files\course assets\SourceDB\Sequences\CityID.sql |
96 |
17ED35C8 |
Exercise Files\course assets\SourceDB\Sequences\CountryID.sql |
97 |
B0FF45C4 |
Exercise Files\course assets\SourceDB\Sequences\PaymentMethodID.sql |
101 |
DD86BC8C |
Exercise Files\course assets\SourceDB\Sequences\PersonID.sql |
97 |
DBF8B3CD |
Exercise Files\course assets\SourceDB\Sequences\StateProvinceID.sql |
102 |
28BABBBB |
Exercise Files\course assets\SourceDB\Sequences\TransactionTypeID.sql |
104 |
577A5305 |
Exercise Files\course assets\SourceDB\SourceDB.dbmdl |
8,740,614 |
81B5F9FA |
Exercise Files\course assets\SourceDB\SourceDB.jfm |
16,384 |
DC55FAEF |
Exercise Files\course assets\SourceDB\SourceDB.publish.xml |
763 |
AB718515 |
Exercise Files\course assets\SourceDB\SourceDB.sqlproj |
8,468 |
44780A16 |
Exercise Files\course assets\SourceDB\SourceDB.sqlproj.user |
147 |
C57F49E5 |
Exercise Files\course assets\SSIS_Demo\SSIS_Demo.dtproj.user |
563 |
22A96680 |
Exercise Files\course assets\TargetDB\App\Functions\ElapsedTimeCompact.sql |
2,077 |
EF85EAC4 |
Exercise Files\course assets\TargetDB\App\Functions\ElapsedTimeText.sql |
3,169 |
16BA4E46 |
Exercise Files\course assets\TargetDB\App\Functions\ElapsedTimeTextCompact.sql |
3,219 |
1B47C0C2 |
Exercise Files\course assets\TargetDB\App\Stored Procedures\LogMessage.sql |
682 |
C7F63335 |
Exercise Files\course assets\TargetDB\App\Stored Procedures\PackageRunnerInitialLoad.sql |
1,915 |
A0AC768D |
Exercise Files\course assets\TargetDB\App\Stored Procedures\ShowDebugLog.sql |
650 |
0223362C |
Exercise Files\course assets\TargetDB\App\Table\DebugLog.sql |
823 |
C3AC52F0 |
Exercise Files\course assets\TargetDB\App\Table\PackageLogger.sql |
1,102 |
00CC2518 |
Exercise Files\course assets\TargetDB\App\Table\PackageRunner.sql |
1,809 |
9ADAFC09 |
Exercise Files\course assets\TargetDB\App\Views\PackageLogInProgress.sql |
1,899 |
9AB77E4C |
Exercise Files\course assets\TargetDB\App\Views\PackageLogMasterRuns.sql |
1,973 |
003C854E |
Exercise Files\course assets\TargetDB\App\Views\PackageLogMasterRunsToday.sql |
2,213 |
50F2849B |
Exercise Files\course assets\TargetDB\App\Views\PackageLogToday.sql |
2,031 |
F7981369 |
Exercise Files\course assets\TargetDB\Dimension\Tables\City.sql |
6,236 |
3F42A2AE |
Exercise Files\course assets\TargetDB\Dimension\Tables\Employee.sql |
4,474 |
62C2DF6E |
Exercise Files\course assets\TargetDB\Dimension\Tables\PaymentMethod.sql |
3,384 |
7215EA28 |
Exercise Files\course assets\TargetDB\Dimension\Tables\TransactionType.sql |
3,482 |
F4C83F0A |
Exercise Files\course assets\TargetDB\PostDeploymentScripts\Script.PostDeployment1.sql |
1,187 |
F4E4167D |
Exercise Files\course assets\TargetDB\Security\App.sql |
295 |
A8FEEF30 |
Exercise Files\course assets\TargetDB\Security\Application.sql |
248 |
14F2274A |
Exercise Files\course assets\TargetDB\Security\Dimension.sql |
248 |
0F2AAF3E |
Exercise Files\course assets\TargetDB\Security\Integration.sql |
283 |
897885BD |
Exercise Files\course assets\TargetDB\Security\Sequences.sql |
267 |
AA3FC970 |
Exercise Files\course assets\TargetDB\Sequences\Sequences\CityKey.sql |
93 |
214770D1 |
Exercise Files\course assets\TargetDB\Sequences\Sequences\Employee.sql |
97 |
06925D90 |
Exercise Files\course assets\TargetDB\Sequences\Sequences\PaymentMethodKey.sql |
102 |
1F6E70C5 |
Exercise Files\course assets\TargetDB\Sequences\Sequences\TransactionTypeKey.sql |
104 |
F39381C8 |
Exercise Files\course assets\TargetDB\TargetDB.dbmdl |
56,177,694 |
4A52D601 |
Exercise Files\course assets\TargetDB\TargetDB.jfm |
16,384 |
9D33981E |
Exercise Files\course assets\TargetDB\TargetDB.sqlproj |
6,010 |
2D926B83 |
Exercise Files\course assets\TargetDB\TargetDB.sqlproj.user |
147 |
C57F49E5 |
Exercise Files\course assets\TargetDB\TargetDB_Dev.publish.xml |
767 |
270C0052 |
Exercise Files\course assets\TargetDB\TargetDB_Prod.publish.xml |
773 |
00B7AC46 |
Exercise Files\course assets\TargetDB\TargetDB_Test.publish.xml |
773 |
26430FDA |
Exercise Files\course assets\Demo_SSIS\bin\Development |
0 |
00000000 |
Exercise Files\course assets\Demo_SSIS\obj\Development |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Application\Tables |
0 |
00000000 |
Exercise Files\course assets\SourceDB\bin\Debug |
0 |
00000000 |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Functions |
0 |
00000000 |
Exercise Files\course assets\SourceDB\DataLoadSimulation\Stored Procedures |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Integration\Stored Procedures |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Integration\Tables |
0 |
00000000 |
Exercise Files\course assets\SourceDB\obj\Debug |
0 |
00000000 |
Exercise Files\course assets\TargetDB\App\Functions |
0 |
00000000 |
Exercise Files\course assets\TargetDB\App\Stored Procedures |
0 |
00000000 |
Exercise Files\course assets\TargetDB\App\Table |
0 |
00000000 |
Exercise Files\course assets\TargetDB\App\Views |
0 |
00000000 |
Exercise Files\course assets\TargetDB\bin\Debug |
0 |
00000000 |
Exercise Files\course assets\TargetDB\Dimension\Tables |
0 |
00000000 |
Exercise Files\course assets\TargetDB\obj\Debug |
0 |
00000000 |
Exercise Files\course assets\TargetDB\Sequences\Sequences |
0 |
00000000 |
Exercise Files\course assets\Demo_SSIS\bin |
0 |
00000000 |
Exercise Files\course assets\Demo_SSIS\obj |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Application |
0 |
00000000 |
Exercise Files\course assets\SourceDB\bin |
0 |
00000000 |
Exercise Files\course assets\SourceDB\DataLoadSimulation |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Integration |
0 |
00000000 |
Exercise Files\course assets\SourceDB\obj |
0 |
00000000 |
Exercise Files\course assets\SourceDB\PostDeploymentScripts |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Security |
0 |
00000000 |
Exercise Files\course assets\SourceDB\Sequences |
0 |
00000000 |
Exercise Files\course assets\TargetDB\App |
0 |
00000000 |
Exercise Files\course assets\TargetDB\bin |
0 |
00000000 |
Exercise Files\course assets\TargetDB\Dimension |
0 |
00000000 |
Exercise Files\course assets\TargetDB\obj |
0 |
00000000 |
Exercise Files\course assets\TargetDB\PostDeploymentScripts |
0 |
00000000 |
Exercise Files\course assets\TargetDB\Security |
0 |
00000000 |
Exercise Files\course assets\TargetDB\Sequences |
0 |
00000000 |
Exercise Files\course assets\Demo_SSIS |
0 |
00000000 |
Exercise Files\course assets\Documentation |
0 |
00000000 |
Exercise Files\course assets\Monitoring_SSIS_Projects |
0 |
00000000 |
Exercise Files\course assets\SourceDB |
0 |
00000000 |
Exercise Files\course assets\SSIS_Demo |
0 |
00000000 |
Exercise Files\course assets\TargetDB |
0 |
00000000 |
Exercise Files\02 |
0 |
00000000 |
Exercise Files\03 |
0 |
00000000 |
Exercise Files\04 |
0 |
00000000 |
Exercise Files\05 |
0 |
00000000 |
Exercise Files\06 |
0 |
00000000 |
Exercise Files\07 |
0 |
00000000 |
Exercise Files\08 |
0 |
00000000 |
Exercise Files\09 |
0 |
00000000 |
Exercise Files\10 |
0 |
00000000 |
Exercise Files\11 |
0 |
00000000 |
Exercise Files\12 |
0 |
00000000 |
Exercise Files\13 |
0 |
00000000 |
Exercise Files\course assets |
0 |
00000000 |
01. Course Overview |
0 |
00000000 |
02. Introduction |
0 |
00000000 |
03. Creating and Managing the Catalog |
0 |
00000000 |
04. Deploying to the Catalog |
0 |
00000000 |
05. Using Canned Dashboard Reports |
0 |
00000000 |
06. Implementing Parallelism for Faster Loading in SSIS |
0 |
00000000 |
07. Configuring a Project or Package |
0 |
00000000 |
08. Managing Variables and Connection Strings through Environments |
0 |
00000000 |
09. Using the Catalog for Logging |
0 |
00000000 |
10. Developing Custom Logging |
0 |
00000000 |
11. Creating an SSIS Package Template for Re-use |
0 |
00000000 |
12. Creating Reusable Units of an SSIS Package Workflow |
0 |
00000000 |
13. Summary |
0 |
00000000 |
Exercise Files |
0 |
00000000 |
|
Total size: |
558,908,241 |
|